34,576
社区成员
发帖
与我相关
我的任务
分享
DECLARE @T TABLE (ID INT,NAME VARCHAR(100),CLASS VARCHAR(100),COUNT INT,DATE INT)
INSERT INTO @T
SELECT 1,'苹果','水果',10,20110701 UNION ALL
SELECT 1,'桔子','水果',10,20110702 UNION ALL
SELECT 1,'香蕉','水果',10,20110703 UNION ALL
SELECT 2,'白菜','蔬菜',10,20110701 UNION ALL
SELECT 2,'青菜','蔬菜',10,20110702
SELECT *
FROM @T A
WHERE EXISTS
(SELECT 1 FROM @T B
WHERE B.ID = A.Id AND B.DATE < A.Date)