Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 120096 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / uday
Hi friends i think it is surely work because i worked for this.
select * from emp e where 1=(select count(distinct d.esal)
from emp d where d.esal>e.esal)
any one plz try if it's not work
plz let me know.
uday_testing@yahoo.co.in
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is 'trigger' in sql? : Sql dba
What does seeding a database mean?
How to call a javascript function from pl sql?
What are %type and %rowtype for?
How many types of normalization are there?
What is cte sql?
What is mutating error in pl sql?
What is forward declaration in pl sql?
How is a process of pl/sql compiled?
Why we use joins in sql?
Explain what is a column in a table?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the difference between the sql*loader and import utilities? : aql loader
