OraFAQ Forum: SQL & PL/SQL » select distinct all

Home » SQL & PL/SQL » SQL & PL/SQL » select distinct all

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

select distinct all [message #19385]

Wed, 13 March 2002 15:26

Fari
Messages: 5
Registered: March 2002

Junior Member

how do select distinct for all records
eg
where will l put the distinct function so that it covers all the fields.

select a,s,d,f,g
from dcfg

somrthing like select distinct(a,s,....

Report message to a moderator

Re: select distinct all [message #19386 is a reply to message #19385]

Wed, 13 March 2002 18:32

sokeh
Messages: 77
Registered: August 2000

Member

how about select distinct a,s,d,f,g
from dcfg

Report message to a moderator

Re: select distinct all [message #19400 is a reply to message #19385]

Thu, 14 March 2002 08:04

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select distinct *
  from dcfg

Report message to a moderator

Previous Topic:	ORA-00918 : column ambiguously defined. Please help
Next Topic:	Datmodeling

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 19:05:30 CDT 2024