OraFAQ Forum: Forms

Thu, 27 July 2006 03:47

m3_suja
Messages: 5
Registered: July 2006

Junior Member

What is the query to find out the first top 4salary from the Emp table

Thu, 27 July 2006 04:34

jowahl
Messages: 82
Registered: May 2006

Member

again: this is the FORMS forum ...

SELECT * FROM (SELECT salary FROM table ORDER BY salary DESC) WHERE ROWNUM < 5;

Previous Topic:	Calling a function
Next Topic:	How to move cursor..

Goto Forum:

]

Current Time: Fri Sep 20 11:25:58 CDT 2024