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
- 29452 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / naresh
select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is secondary key?
What are types of indexes in sql?
Is sql a dbms?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is a stored procedure in sql with example?
What are all the different normalizations?
Where the sql database files are stored?
What is the maximum rows in csv?
Why is pl sql used?
List the various privileges that a user can grant to another user?
How many sql statements are used? Define them.
What is the maximum size of sqlite database?
Why do we use triggers?
How to fetch alternate records from a table?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
