select top 1 * from [table] order by lastupdate desc
select max(laseupdate) from tableselect top 1 * from table order by laseupdate desc
SELECT * FROM TB T WHERE NOT EXISTS(SELECT 1 FROM TB WHERE ID=T.ID AND lastupdate >T.lastupdate )?
SELECT TOP 1 * FROM TB ORDER BY lastupdate DESC?
SELECT * FROM TB T WHERE NOT EXISTS(SELECT 1 FROM TB WHERE lastupdate >T.lastupdate )
--1、 select max(laseupdate) from table --2、 select top 1 * from table order by laseupdate desc --3、 SELECT * FROM TB T WHERE NOT EXISTS (SELECT 1 FROM TB WHERE ID=T.ID AND lastupdate >T.lastupdate )
SELECT TOP 1 * FROM TB ORDER BY lastupdate DESCSELECT max(lastupdate) as 最大日期 FROM TB
select top 1 * from [table] order by lastupdate desc
select max(laseupdate) from table --2、
select top 1 * from table order by laseupdate desc
--3、
SELECT * FROM TB T
WHERE
NOT EXISTS
(SELECT 1 FROM TB WHERE ID=T.ID AND lastupdate >T.lastupdate )