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 the data pump import utility?
Explain alias?
How to get a list of all user accounts in the database?
what are bitmap indexes? How does they work?
Explain the function of optimizer in oracle?
How many file formats are supported to export data?
How to display employee records who gets more salary than the average salary in the department?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to check the server version in oracle?
What are the benefits of ordbms?
how can we store any pdf file in oracle
How can you use check constraints for self referential integrity?
What is the difference between translate and replace in oracle?
What do you mean by a tablespace?
What is the difference between post-database commit and post-form commit?