how to check the 3rd max salary from an employee table?
- 23 Answers
- 30118 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 an inner join sql?
What is sql character function?
Is it possible to link two groups inside a cross products after the cross products group has been created?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What pl/sql package consists of?
Explain spool.
What are stuff and replace function?
what is a table in a database ? : Sql dba
What is a primary key sql?
Does sql*plus also have a pl/sql engine?
what are the differences between char and varchar? : Sql dba
what is 'mysqlimport'? : Sql dba
What are data types in pl sql?
Are stored procedures faster than queries?
How do I view an execution plan in sql?
