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
- 29356 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
Which is better varchar or nvarchar?
Why is pl sql needed?
Which is faster count (*) or count 1?
what is 'mysqld'? : Sql dba
What is a recursive stored procedure?
What port does sql server use?
Does pdo prevent sql injection?
Explain lock escalation? : Transact sql
How does rowid help in running a query faster?
what does myisamchk do? : Sql dba
What mean sql?
Is sql harder than python?
Explain the uses of control file.
What are predefined functions in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
