Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 28904 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / raghuvir
select * from employee where salary = (
select min(salary) from (
select distinct(salary) from employee
order by salary desc)
where rownum <=5)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why we use stored procedure instead of query?
which types of join is used in sql widely? : Sql dba
What is sql select statement?
What is the difference between row level and statement level trigger?
What is a string data type in sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
Is json a nosql?
Write an sql query to select all records from the table?
What is procedure explain with example?
What is error ora-01000: maximum open cursors exceeded
What is a rank in sql?
what is the difference between group by and order by in sql? : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the difference between drop and truncate commands?
What is partition by in sql?
