(Id唯一,Date选最近的一次)
执行下面两种方法的结果:
SELECT Id, Name, Class, COUNT, Date
FROM test t WHERE (Date = (SELECT MAX(Date) FROM test WHERE Id = t .Id))
SELECT * FROM dbo.test a WHERE NOT EXISTS(SELECT * FROM test WHERE a.id=id AND date>a.date)
(Id唯一,Date选最近的一次)
执行下面两种方法的结果:
SELECT Id, Name, Class, COUNT, Date
FROM test t WHERE (Date = (SELECT MAX(Date) FROM test WHERE Id = t .Id))
SELECT * FROM dbo.test a WHERE NOT EXISTS(SELECT * FROM test WHERE a.id=id AND date>a.date)