Query

[ILUVORA]

Hi,

The query will return me 10 rows. I want to display only 3 rows. I dont want to use rownum or rank(). What is the alternative solution.

SELECT * FROM (SELECT EMPNO,ENAME FROM EMP ORDER BY EMPNO DESC)

Regards,

Sampath

[bensr]

In that case use a cursor and loop 3 times.
Or delete 7 rows.

[Ao]

Use of analitic functions is the alternative solution.

SELECT * FROM (SELECT EMPNO,ENAME , row_number() over( ORDER BY EMPNO DESC) rn FROM scott.EMP )
where rn < 4