limit rows returned

[Guest_imported]

Hi there,

How do I limit the number of rows returned by SQL

Alasdair

 

[carp]

Try using rownum:

SELECT * FROM my_table WHERE rownum < 6;

will return no more than five rows.

 

[buzzlightyear]

Try using the WHERE clause to restrict the number of rows to be fetched.

Example :

SELECT *
FROM emp
WHERE empno = 8349;

or

SELECT *
FROM emp
WHERE sal > 1500;

Hope this help

 

[rakesh1]

BETWEEN

TRY TO USE BETWEEN CLAUSE BECAUSE IT WOULD GIVE YOU THE
EXACT DESIRED RESULT.

SELECT * FROM EMP
WHERE
SAL BETWEEN 1000 AND 3000;