Re: Limiting number of returning rows

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Wed, 22 Jul 1998 15:43:37 GMT
Message-ID: <01bdb597$511ebce0$a504fa80@mndnet>

Use
where rownum < 101
to return 100 rows, only problem is that with this simple where clause you cannot use order by clause.
Also you can only use < operator to be meaningful with ROWNUM pseudo column.
If you need to sort the rows then there are otherway to do it

Good luck !!!

suresh.baht_at_mitchell-energy.com

john2335_at_my-dejanews.com wrote in article <6p4s77$j0p$1_at_nnrp1.dejanews.com>...
> Is there a syntax in oracle to limit number of returning rows
> in a single SQL call?
> I know you can do it in Sybase using: set row NUMBER_OF_ROW
>
> Tanks
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Wed Jul 22 1998 - 10:43:37 CDT