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 there be 2 primary keys in a table?

952

Does truncate need commit?

895

how to start mysql server? : Sql dba

1147

How many joins in sql?

948

Does pl/sql support create command?

1045

Is and as keyword in pl sql?

908

Does db2 use sql?

891

What is replication id?

886

Why is normalization important?

973

what is the difference between cluster and non cluster index? : Sql dba

958

What is a constraint? Tell me about its various levels.

1085

how many groups of data types? : Sql dba

974

What is sql*loader?

1076

How to run pl sql program in mysql?

942

what are the different type of sql's statements ? : Sql dba

874