how to get second highest salary in SQL(as/4000
Answer Posted / selvaraj v , anna univ coe
SELECT * FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee x
WHERE x.Salary >= e.Salary);
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
explain advantages of innodb over myisam. : Sql dba
How can one get sql*loader to commit only at the end of the load file? : aql loader
How do I turn a list into a table?
Can we delete column in sql?
How to take user input in pl sql?
What is package in pl sql?
What is the use of primary key?
How to set up sql*plus output format in oracle?
Explain ddl statements in pl/sql?
What is difference between stored function and application function?
Can cursors be part of a trigger body?
what is user defined functions? : Sql dba
What is memory optimized?
Explain spool.
What is sql*loader and what is it used for? : aql loader