一个查询

[sisiz]

TB
FILE1 FILE2
A 1
A 2

B 3

要
A 1

B 3
结果怎么写？

[水族杰纶]

select * from tb  t where not exists(select 1 from tb where file1=t.file1 and file2<t.file2)

[让你望见影子的墙]

select file1, min(file2) as file2
from tb
group by file1

??

[liangCK]

SELECT FILE1,MIN(FILE2) FILE2
FROM tb
GROUP BY FILE1

[水族杰纶]

select file1,min(file2) from tb group by file1

[数字化从业者老高]

统计？

SELECT FILE1,sum(FILE2) AS sum1
FROM tb
GROUP BY FILE1

[fcuandy]

http://topic.csdn.net/u/20080123/18/9731d130-0d4b-4c11-8d89-f2c3ca331f0c.html

[super_iven]

[Quote=引用 2 楼 HEROWANG 的回复:]
select file1, min(file2) as file2
from tb
group by file1

??
[/Quote]

正解

[rockyvan]

AB之間怎麽還有一個空行？允許有空記錄？

[数字化从业者老高]

create table Tb(file1 varchar(5),file2 int)
insert Tb
select 'A',1 union all
select 'A',2 union all
select 'B',3

SELECT FILE1,sum(FILE2) AS sum1 FROM tb GROUP BY FILE1

drop table Tb

结果：

(3 行受影响)
FILE1 sum1
----- -----------
A 3
B 3

(2 行受影响)

[jimoshatan]

GROUP BY取最小

[数字化从业者老高]

回答错误了。

修改：

如果需要的每个file1的最小值，使用min；

select file1,min(file2) from tb group by file1

[richnaly]

[Quote=引用 3 楼 liangCK 的回复:]
SELECT FILE1,MIN(FILE2) FILE2
FROM tb
GROUP BY FILE1
[/Quote]
可以的，呵呵

[fa_ge]

    
create table Tb(file1 varchar(5),file2 int)
insert Tb
select 'A',1 union all
select 'A',2 union all
select 'B',3
    
select * from Tb a
where (select Count(1) from Tb where a.file1=file1 and a.file2>file2 )<1 
/*
file1 file2
----- -----------
A     1
B     3

(2 行受影响)   
*/

[shixianwei]

select t.file1,t.file2 from tb where t.file2 in(select min(s.file2) from tb s group by s.file1)试试这个

[linguojin11]

都OK了。。。