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
- 29353 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / mrunali
select name from (select e.*, dense_rank() over (order by salary desc nulls last)as rn from emp e) where rn=5
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we change the table name in sql?
How to run pl sql program in mysql?
What is db journal file?
what is single byte over head in oracle..?
How would you reference column values before and after you have inserted and deleted triggers?
What is the purpose of the sql select top clause?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Which command is used to delete a package?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is dbms? : Sql dba
What is null in pl/sql?
Why do we use function in pl sql?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is the benefit of foreign key?
Does asenumerable execute the query?
