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
Why truncate is used in sql?
Can function return multiple values in sql?
what is the difference between union and union all? : Sql dba
What are the most important characteristics of pl/sql?
Is inner join same as self join?
what is a view? : Sql dba
What is sqlcommand?
what is a foreign key ? : Sql dba
What is the usage of the distinct keyword?
Is sql a backend?
How you improve the performance of sql*loader? : aql loader
What are field types?
What does over partition by mean in sql?
How do I view stored procedures?
Is sql difficult?