Selecting just one row

**irivera** · 03-31-2004 01:10 PM

How can I select just one row from a table with the same value in multiple rows?

**patel_dil** · 03-31-2004 01:13 PM

select Distinct?

**irivera** · 03-31-2004 02:11 PM

I tried that.

**marist89** · 03-31-2004 02:47 PM

Crystal ball broken today. Maybe you could elaborate with an example?

**tamilselvan** · 03-31-2004 03:06 PM

select id, count(*)
from table_A
group by id
having count(*) > 1;

Is that you want?

Tamil

**Mr.Hanky** · 03-31-2004 03:18 PM

Where rownum <2 ?

**irivera** · 04-01-2004 09:40 AM

YES! The ROWNUM < 2 worked. Thank you all of you out there for your help.

**fossil** · 04-01-2004 11:54 AM

select id
from table
group by id;

**Mr.Hanky** · 04-01-2004 12:29 PM

Originally posted by irivera
YES! The ROWNUM < 2 worked. Thank you all of you out there for your help.

Wow, now I am a genius!

MH

Thread: Selecting just one row