Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 39039 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 are aggregate and scalar functions? : Sql dba
Is primary key always clustered index?
What is the current version of postgresql?
what is schema? : Sql dba
What is the current version of sql?
How do I remove duplicates in two columns?
how to start mysql server? : Sql dba
how to escape special characters in sql statements? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
Can we rollback truncate?
how many tables will create when we create table, what are they? : Sql dba
define sql insert statement ? : Sql dba
what is bcp? When does it used? : Sql dba
Can we use distinct and group by together?
Does group by remove duplicates?
