Home » Developer & Programmer » Forms » QUERY
QUERY [message #184605] Thu, 27 July 2006 03:47 Go to next message
m3_suja
Messages: 5
Registered: July 2006
Junior Member
What is the query to find out the first top 4salary from the Emp table
Re: QUERY [message #184622 is a reply to message #184605] Thu, 27 July 2006 04:34 Go to previous message
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 Dec 02 16:34:15 CST 2016

Total time taken to generate the page: 0.08493 seconds