100分求一条Sql

[new_life]

表Table1
id name
1 a
1 b
1 c
2 d
2 e
2 f
4 a
5 a
5 t
6 y
6 g
目标：
id name
1 a
2 d
4 a
5 a
6 y
写一条sql怎么实现

[ygchu70]

楼上几位写的和楼主给定的条件不一直啊，是楼主写错了？？？前面的是min（name），但是最后一个数据并不是给定的名字最小啊

[ljian_mail]

select a.id,a.name from table1 a where a.rowid=(select min(b.rowid) from
table2 b where a.id=b.id)

[马前小卒]

关注

[txlicenhe]

select * from table1 a
where rowid=(select min(rowid) from table1 where id=a.id)

[tyrone98]

select a.id , frist_value( a.name ) from table1 a group by a.id

[bzszp]

select id,min(name) name from table1 group by id;

[dinya2003]

不排序吗? 一楼的可以把每个id对应的最小记录找出来.

[suleen]

要排序也是这样:
select id,min(name)
from table1
group by id
order by id
赤赤 赤赤.

[feiyingjames]

min函数不是单行函数，不能用where.
select a.id , a.name from table1 a
group by a.id
having a.rowid=1

[cswhj]

select distinct id,min(name) from table1 group by id order by id;

[feiyingjames]

首先，我建立的表跟斑竹的表几乎是一样的，方法也是一样的。
SQL> select *
2 from tbtry
3 /

ID NAME
---------- ----------
1 a
1 b
2 c
2 d
3 a
4 s
5 y
5 f
方法一
SQL> select a.id,a.name
2 from tbtry a,(select min(rowid) minrowid
3 from tbtry
4 group by id) b
5 where a.rowid in b.minrowid
6 /

ID NAME
---------- ----------
1 a
2 c
3 a
4 s
5 y
方法二
SQL> select id,name
2 from tbtry
3 where rowid in (select min(rowid)
4 from tbtry
5 group by id)
6 /

ID NAME
---------- ----------
1 a
2 c
3 a
4 s
5 y