OraFAQ Forum: Server Administration » Displaying a single row

Home » RDBMS Server » Server Administration » Displaying a single row

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

Displaying a single row [message #371968]

Thu, 28 December 2000 02:20

Alvin
Messages: 7
Registered: December 2000

Junior Member

How do I display a single row even if there are other rows with the same value?

e.g.
from this

name id_no
Alvin 123
Alvin 123
Alvin 123
Tiger 456
Tiger 456

to this

name id_no
Alvin 123
Tiger 456

Thanks!

Report message to a moderator

Re: Displaying a single row [message #371969 is a reply to message #371968]

Thu, 28 December 2000 04:19

Marcus Fernando
Messages: 34
Registered: September 2000

Member

SELECT DISTINCT field1, field2
FROM table;

Report message to a moderator

Re: Displaying a single row [message #371970 is a reply to message #371969]

Thu, 28 December 2000 04:25

Alvin
Messages: 7
Registered: December 2000

Junior Member

Thanks a lot Marcus.

Cheers,
Alvin

Report message to a moderator

Previous Topic:	Dynamyic SQL
Next Topic:	Procedure Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 13:29:16 CDT 2024