find out the third highest salary?
Answer Posted / nirad
select Top 1 *
from ( select top 3 * from Customer order by salary desc )
tempt
order by salary asc
if you want third lowest just desc with asc and asc with
desc and even if you want 2 or other hight value just
change inner query value of 3
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is dynamic proxy?
What is the difference between alert log file and tarce file ?
Can we store images in oracle database?
Explain the use of ignore option in imp command.
How to sort output in descending order in oracle?
How can Oracle users be audited?
Hi Can any one tell me what are the API's used in requisition import.
Explain do view contain data?
What are the attributes of the cursor?
what are steps for interface? where is exchange rate defined in which table?
How much memory your 10g xe server is using?
Explain an extent?
Explain an exception and its types?
Which environment variables are absolutely critical in order to run the OUI?
Can group functions be mixed with non-group selection fields?