一个关于select语句的问题

[javaxi]

一个表tbl1，数据如下：
col1 col2 col3 col4 col5 col6
A 1 2008-10-10 1 2 3
A 1 2008-10-01 5 4 1
A 1 2008-10-11 1 1 1
A 1 2008-10-15 2 2 2
B 2 2008-09-11 1 2 1
B 2 2008-09-10 2 2 1
B 2 2008-09-15 7 4 6
select 的时候，根据col1,col2分组，只显示日期最小那条数据，该如何实现？
希望得到的结果是：
A 1 2008-10-01 5 4 1
B 2 2008-09-10 2 2 1

select * from tbl1 group by col1, col2 having……
该如何编写呢？

[水族杰纶]

select * from tbl1 t where not exists(select 1 from tbl1 where col1=t.col1 and col2=t.col2 and col3>t.col3)

[lgxyz]

select * from tbl1 a 
where not exists(select 1 from tal1  where col1=a.col1 and col2=a.col2 and col3<a.col3)

[昵称被占用了]

select * from tbl1 a
where not exists (
  select 1 from tbl1
  where col1=a.col1
  and col2=a.col2
  and col3<a.col3
  )

[水族杰纶]

反了
[Quote=引用 1 楼 wufeng4552 的回复:]
select * from tbl1 t where not exists(select 1 from tbl1 where col1=t.col1 and col2=t.col2 and col3<t.col3)
[/Quote]

[113244]

关注。。

[wxg22526451]

select * from @T a
where col3 in(select MIN(col3) from @T group by col1,col2)

[tcxx2008]

关注中...

分组他们没说,自己补上