Home » SQL & PL/SQL » SQL & PL/SQL » SELECT DISTINCT command
SELECT DISTINCT command [message #21489] Wed, 07 August 2002 13:47 Go to next message
Justin Davies
Messages: 1
Registered: August 2002
Junior Member
How can I pull a listing of all distinct values for 2 different columns. I cannot use :-
select distinct(table_name), distinct(owner) from ...

Can I ?

Report message to a moderator

Re: SELECT DISTINCT command [message #21490 is a reply to message #21489] Wed, 07 August 2002 13:49 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select distinct table_name, owner
  from ...

Report message to a moderator

Previous Topic: To_Char Problems
Next Topic: DDL using PL/SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:35:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.