SQL语句中exists和not exists的用法,讲得通俗易懂些。答:正确的SQL语句是:SELECT Id, Name, Class, Count, Date FROM table t WHERE (NOT EXISTS (SELECT Id, Name, Class, Count, Date FROM table WHERE Id = t.Id AND Date > t.Date))如果用distinct,得不到这个结果, 因为distinct是作用与所有列的 SELECT DISTINCT Id, Name, Class, Count, ...