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
How can I introduce multiple conditions in like operator?
How to run queries on external tables?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Where do we use decode and case statements?
Explain oracle 12c new features for developers?
What are the common oracle dba tasks?
How to shutdown your 10g xe server?
How to best split csv strings in oracle 9i?
How to handle a single quote in oracle sql?
What is oracle used for?
WHAT IS ecc 6.0
How many types of synonyms in Oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is snapshot is too old? Give and example for better understand.
What is catalog in Oracle?