SELECT salary FROM (SELECT salary FROM emp ORDER BY DESC salary)

Write a query to find second highest salary of an employee.

Question Posted / kitcat

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

Please Help Members By Posting Answers For Below Questions

What language is oracle sql developer?

963

Which version of sql do I have?

1023

What normalization means?

929

What is rtm in testing?

1071

Explain dml and ddl?

941

Explain the order of sql statement execution?

1003

How to order siblings in oracle hierarchy queries?

1008

What are pl/sql cursors?

1020

What is plpgsql language?

1010

How do you write an inner join query?

918

How does one use sql*loader to load images, sound clips and documents? : aql loader

1145

what is a table in a database ? : Sql dba

1012

What is sql and explain its components?

1033

How do I run a program in pl sql?

977

What are tables in sql?

1022