CREATE TABLE TEST(A NCHAR(1),B INT) INSERT TEST SELECT 'a', 1 INSERT TEST SELECT 'a', 2 INSERT TEST SELECT 'b', 1 INSERT TEST SELECT 'c', 3 SELECT * FROM TESTSELECT * FROM TEST I WHERE NOT EXISTS(SELECT 1 FROM TEST J WHERE J.A=I.A AND J.B<I.B)DROP TABLE TEST
CREATE TABLE TEST(A NCHAR(1),B INT) INSERT TEST SELECT 'a', 1 INSERT TEST SELECT 'a', 2 INSERT TEST SELECT 'b', 1 INSERT TEST SELECT 'c', 3select A,min(B) from tab group by A
drop table tt create table tt(A varchar(10),B int) insert tt select 'a',1 union all select 'a',2 union all select 'b',1 union all select 'c',3select A, MIN(DISTINCT B) as B from tt group by A
INSERT TEST SELECT 'a', 1
INSERT TEST SELECT 'a', 2
INSERT TEST SELECT 'b', 1
INSERT TEST SELECT 'c', 3
SELECT * FROM TESTSELECT * FROM TEST I WHERE NOT EXISTS(SELECT 1 FROM TEST J WHERE J.A=I.A AND J.B<I.B)DROP TABLE TEST
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) 最新版本:20070130http://www.cnblogs.com/feiyun0112/archive/2006/09/20/509783.html
INSERT TEST SELECT 'a', 1
INSERT TEST SELECT 'a', 2
INSERT TEST SELECT 'b', 1
INSERT TEST SELECT 'c', 3select A,min(B) from tab group by A
create table tt(A varchar(10),B int)
insert tt select 'a',1
union all select 'a',2
union all select 'b',1
union all select 'c',3select A, MIN(DISTINCT B) as B
from tt
group by A