OraFAQ Forum: SQL & PL/SQL » limiting distinct value results

Home » SQL & PL/SQL » SQL & PL/SQL » limiting distinct value results

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

limiting distinct value results [message #8734]

Mon, 22 September 2003 12:24

DR
Messages: 12
Registered: July 2003

Junior Member

I have the following:
select distinct intst
from owner.tableone
where intst is not null;

The result values are:
4
104
204
304
404
504

For an application sample, I only want the first three values (4, 104, 204). How would I limit the output from the select?

TIA - Denise

Report message to a moderator

Re: limiting distinct value results [message #8735 is a reply to message #8734]

Mon, 22 September 2003 12:47

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

If you want only the first three (smallest values):

select *
  from (select distinct intst
          from owner.tableone
         where intst is not null
         order by intst)
 where rownum <= 3;

If you only want any three:

select distinct intst
  from owner.tableone
 where intst is not null
   and rownum <= 3;

Report message to a moderator

Re: limiting distinct value results [message #8737 is a reply to message #8735]

Mon, 22 September 2003 12:55

DR
Messages: 12
Registered: July 2003

Junior Member

Thanks, Todd!
The first query is the one that I was needing. - Denise

Report message to a moderator

Previous Topic:	Finding tables with given field and given values
Next Topic:	two phase commit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:04:08 CDT 2024