SELECT e1.* from ( SELECT last_name, salary, DENSE

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

Question Posted / oboyah

Answer Posted / oboyah

SELECT e1.* from ( SELECT last_name, salary,
DENSE_RANK() OVER ( ORDER BY salary DESC) rank
FROM employees) e1 where e1.Rank = 2;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can I create table without primary key?

981

Is join same as left join?

1020

how to check server status with 'mysqladmin'? : Sql dba

1049

how to concatenate two character strings? : Sql dba

1074

How do you write an inner join query?

934

Is sql similar to python?

959

Are sql connections encrypted?

998

Can you have more than one key in a database?

916

Is sqlite free?

948

How to run pl/sql statements in sql*plus?

1058

What is sql scripting?

1090

Does sap use sql?

960

how can you create an empty table from an existing table? : Sql dba

1132

How to Execute a Package in PL/SQL.?

1182

Which are sql * plus commands?

1105