求教一查询语句！！！救急啊！！高手们！！
表A name scot
a 1
b 1
c 1
d 2
e 2

实现成： a 1
d 2

问题2： 实现成： a b 1
a c 1
b c 1
d e 2

[解决办法]
1. select min(name),scot from A group by scot
[解决办法]
select
t.*
from
表 t
where
not exists(select 1 from 表 where name <t.name and scot=t.scot)

select
a.name,b.name,a.scot
from
表 a,表 b
where
a.scot=b.scot and a.name <b.name
order by
a.scot.a.name,b.name
[解决办法]
表A name scot
a 1
b 1
c 1
d 2
e 2

实现成： a 1
d 2

select min(name) name,scot from tb group by scot
[解决办法]
--------------例子--------
create table A(name varchar(10),scot int)
insert A
select 'a ',1 union all
select 'b ',1 union all
select 'c ',1 union all
select 'd ',2 union all
select 'e ',2

select min(name),scot from a group by scot

select
a.name,b.name,a.scot
from
a,a b
where
a.scot=b.scot and a.name <b.name
order by
a.scot,a.name,b.name