Re: Limit Rows in sql query output

From: Tim Hall <tim@xxxxxxxxxxxxxxx>
To: Bala Krishna <krishna000@xxxxxxxxx>
Date: Wed, 18 Jun 2014 11:00:42 +0100

It looks like what you are trying to do is a top-n query. This
explains how to do them.

http://www.oracle-base.com/articles/misc/top-n-queries.php

If you were using 12c, you could use the new syntax.

http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php

Cheers

Tim...
--
//www.freelists.org/webpage/oracle-l

References:
- Limit Rows in sql query output
  - From: Bala Krishna

Other related posts:

» Limit Rows in sql query output- Bala Krishna
» RE: Limit Rows in sql query output- Mckay-dirden, Michael (Student)
» RE: Limit Rows in sql query output- Maris Elsins
» Re: Limit Rows in sql query output - Tim Hall
» Re: Limit Rows in sql query output- vijay sehgal
» Re: Limit Rows in sql query output- Kenny Payton
» RE: Limit Rows in sql query output- Mark W. Farnham
» Re: Limit Rows in sql query output- Kenny Payton
» RE: Limit Rows in sql query output- Iggy Fernandez