SELECT * FROM report ORDER BY FinishTime DESC 改为: select * from report where PK in (select top 1 PK from Report order by FinishTime DESC)
select * from report a where PK in (select top 1 PK from Report where a.相同的值列=相同的值列 order by FinishTime DESC)
select * from report a where PK =(select top 1 PK from Report where a.相同的值列=相同的值列 order by FinishTime DESC) or select * from report a where PK in (select top 1 PK from Report where a.相同的值列=相同的值列 order by FinishTime DESC)
列名 'PK' 无效?怎么回事? ------------pk 改为你表中的主键 列名
select * from report a where not exists (select 1 from Report where FinishTime=a.FinishTime and PK<a.PK ) order by FinishTime DESC
改为:
select * from report where PK in (select top 1 PK from Report order by FinishTime DESC)
or
select * from report a where PK in (select top 1 PK from Report where a.相同的值列=相同的值列 order by FinishTime DESC)
------------pk 改为你表中的主键 列名
from report a
where not exists (select 1 from Report where FinishTime=a.FinishTime and PK<a.PK )
order by FinishTime DESC