Home » RDBMS Server » Server Administration » Urgent .. distinct
Urgent .. distinct [message #372919] Sun, 18 March 2001 02:45 Go to next message
Rd
Messages: 6
Registered: March 2001
Junior Member
I have one table with fields name & address.
Name Address
--------------
John San Jose
John Santa clara
Mary San Mateo
Mary Sfo

Now how can i make query to print name only once & addresses for that name.

ex.

John San Jose
Santa clara
Mary San Mateo
Sfo

Please let me know.

Report message to a moderator

Re: Urgent .. distinct [message #372920 is a reply to message #372919] Sun, 18 March 2001 03:49 Go to previous message
Balamurugan.R
Messages: 91
Registered: March 2001
Member
Hai,

try this,

first type
sql> break on name
and then
sql>select name,address from table_name;

u will get the desired result.

With Regards,
Balu

Report message to a moderator

Previous Topic: Index and View
Next Topic: Index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 01:27:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.