Write a query to find second highest salary of an employee.
Answer Posted / kitcat
SELECT salary
FROM (SELECT salary FROM emp
ORDER BY DESC salary)
WHERE RowNum=2
| Is This Answer Correct ? | 1 Yes | 11 No |
Post New Answer View All Answers
What language is oracle sql developer?
Which version of sql do I have?
What normalization means?
What is rtm in testing?
Explain dml and ddl?
Explain the order of sql statement execution?
How to order siblings in oracle hierarchy queries?
What are pl/sql cursors?
What is plpgsql language?
How do you write an inner join query?
How does one use sql*loader to load images, sound clips and documents? : aql loader
what is a table in a database ? : Sql dba
What is sql and explain its components?
How do I run a program in pl sql?
What are tables in sql?