求助一条Sql语句的怎么写


我现在要查询 同一个refno 最后一个评审人的名字（最大的日期，同一个refno，姓名）
请问现在我该怎么写这个语句。
[解决办法]

select * from tb a 
where a.reviewdate=(select max(reviewdate) from tb where refno=a.refno)

SELECT * FROM TB a WHERE reviewdate=(SELECT MAX(reviewdate) FROM TB WHERE refno=a.refno)

select * from tb as a
where not exists(select 1 from tb as x where x.refno=a.refno and x.reviewdate>a.reviewdate)

select * from [Table] T where T.reviewdate = 
(select max(reviewdate) from [Table] where refno = T.refno)