CREATE TABLE T1(a INT,b INT,c INT)
INSERT INTO T1(a,b,c)SELECT 1,2,3UNIONSELECT 2,2,4UNION SELECT 3,3,3UNIONSELECT 4,3,5SELECT *FROM T1WHERE a NOT IN (SELECT MAX(a)
FROM T1GROUP BY b)
CREATE TABLE T1(a INT,b INT,c INT)
INSERT INTO T1(a,b,c)SELECT 1,2,3UNIONSELECT 2,2,4UNION SELECT 3,3,3UNIONSELECT 4,3,5SELECT *FROM T1WHERE a NOT IN (SELECT MAX(a)
FROM T1GROUP BY b)
at
4:25 AM
Labels: SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server Tip
No comments:
Post a Comment