SQL語句顯示問題(100分)

Y

yil9999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #1

字段a, b
a b
1 00
1 01
2 00
2 00
3 02
3 01
怎样用SQL語句查出以下結果呢？
1 00
1 01
3 02
3 01
相同的a, 不同的b。

 

J

Johnny_du

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #2

呵呵：）
1、OnOwnerDraw；
2、OnGetRecord

 

Y

yil9999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #3

Johnny_du， 能不能说更詳細一点呢？謝謝！

 

A

ak_2004

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #4

select a ,b
from table1
group by a,b
having count(*) = 1

 

迷

迷途的羔羊

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #5

select a.a,a.b from (select a,b,count(*) count from table group by a,b) a where a.count<2

 

Y

yil9999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-08-07

• #6

已明白，非常謝謝！