how to find the second highest salary from emp table?
Answer Posted / mallika
SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do I enable sql encryption?
Why do we use sqlite?
What does closing a cursor do?
Explain isolation levels. : Transact sql
What is a sql*loader control file?
What is the order of sql select?
What is the difference between inner join and natural join?
What is scalar function in sql?
what is isam? : Sql dba
What are the advantages of sql?
how to increment dates by 1 in mysql? : Sql dba
What is difference between table and view?
What are different clauses used in sql?
Which is better join or subquery?
What is primary key secondary key alternate key candidate key?