Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 36946 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
Can a select statement fire a trigger?
how to use case expression? : Sql dba
Can we use joins in subquery?
What does pragma mean?
How do I pipe the output of one isql to another?
How do I count rows in sql query?
How do you copy a table in sql?
Do we need commit after truncate?
Why is %isopen always false for an implicit cursor?
is it possible to pass an object or table to a procedure as an argument?
what are the differences between char and varchar? : Sql dba
What is a heap in sql?
How do we accept inputs from user during runtime?
How to create an array in pl/sql?
How does cross join work in sql?
