how to check the 3rd max salary from an employee table?
- 23 Answers
- 32887 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ar
select c.emp_id,c.salary from (select rownum as
rn1,c.emp_id,c.salary from (select * from table_name ORDER
by salary DESC) b) c
where c.rn1 = n --(n=3)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is record type in pl sql?
What is right join in sql?
How do I truncate a word?
When you have to use a default "rollback to" savepoint of plvlog?
What are the advantages of pl sql over sql?
What is embedded sql in db2?
explain mysql aggregate functions. : Sql dba
Explain the savepoint statement.
Is sql a backend?
Can you inner join the same table?
Are views faster than queries?
How do I clear the screen in sql plus?
What is integrity in sql?
What is the use of count (*) in sql?
What are the different sql commands?
