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 is cross join sql?

902

Explain the significance of the & and && operators in pl sql.

985

What is the advantage of nosql?

1039

What is the difference among union, minus and intersect?

982

Write a sql select query that only returns each name only once from a table?

990

Explain lock escalation? : Transact sql

1171

What are the constraints available in sql?

1026

what is the difference difference between procedure and packages

10360

How to order siblings in oracle hierarchy queries?

1019

Why use stored procedures?

1058

Explain the methods used to protect source code of pl/sql.

1006

What are different sql data types?

1012

What is the use of stored procedures?

1019

how to show all tables with 'mysql'? : Sql dba

1090

How to display Row Number with Records in Oracle SQL Plus?

1023