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
- 30109 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / kishore
select salery from (
(select salery ,rownum as num from
(select salery from employees order by salery desc)
where rownum <= 5 ))
where num = 5;
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is sql and its types?
What are the differences between in and exists clause?
Is json a nosql?
what are all the different types of indexes? : Sql dba
How does sql profiler work?
Explain what is a column in a table?
tell me about various levels of constraint. : Sql dba
What are all the common sql functions?
What is difference between mysql and postgresql?
How can we optimize a sql query?
what is the command line end user interface - mysql? : Sql dba
What is the usage of distinct keyword?
What are schema-level triggers?
What are the parts of a basic sql query?
Can unique keys be null?
