Selecting just one row

**irivera** · 03-31-2004, 02:10 PM

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

**patel_dil** · 03-31-2004, 02:13 PM

select Distinct?

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

I tried that.

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

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

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

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

Is that you want?

Tamil

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

Where rownum <2 ?

**irivera** · 04-01-2004, 10:40 AM

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

**fossil** · 04-01-2004, 12:54 PM

select id
from table
group by id;

**Mr.Hanky** · 04-01-2004, 01: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