DISTINCT 的使用(50分)

C

cool_cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-08

• #1

怎样使用DISTINCT使重复记录只显示第一条记录？

 

H

huchunguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-08

• #2

select distinct field from tablename

 

C

cool_cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-08

• #3

to huchunguo
这样只能显示该表的一个字段，如何显示多个字段

 

C

cool_cool

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-08

• #4

接受答案了.

 

H

huchunguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-05-08

• #5

Select distinct field1, field2,... from tablename