Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38632 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 a pdo connection?
What is a recursive stored procedure?
what is csv? : Sql dba
What is sql character function?
What is the sql*loader? : aql loader
What is the difference between cross join and natural join?
How to handle bulk data?
Why use triggers in sql?
How do I pipe the output of one isql to another?
What is string data type in sql?
What is the left table in sql?
what is row? : Sql dba
How do you rename a table in sql?
Can we use the cursor's to create the collection in PL/SQL?
What is on delete restrict?
