Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 102919 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / prasanna
select * from emp where 2(select count(distinct sal) from
emp e where sal>=e.sal);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
what is the difference between $message and $$message? : Sql dba
Explain ttitle and btitle.
What is sql indexing?
Which is better join or subquery?
Can we commit inside a trigger?
How do I create a memory optimized filegroup?
What is sql and db2?
Can one improve the performance of sql*loader? : aql loader
How do you declare a variable in pl sql?
How do you modify a trigger?
What is a clob in sql?
how to create a table index in mysql? : Sql dba
How do you truncate?
How to use sql statements in pl/sql?
Why we use joins in sql?
