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
- 28569 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 are sql injection vulnerabilities?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
What is the purpose of primary key?
how to include numeric values in sql statements? : Sql dba
List and explain the different types of join clauses supported in ansi-standard sql?
Is inner join same as self join?
What is scalar and vector?
what is bcp? When is it used?
What is tuple in sql?
what is clause? : Sql dba
How does sql store data?
How would you pass hints to the sql processor?
How to sort the rows in sql.
What is delimiter in pl sql?
