select e1.* from (select ename,sal,rank() over(order by sal) rank from e

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

Question Posted / sathish p

Answer Posted / sathish p

select e1.* from (select ename,sal,rank()
over(order by sal) rank from emp) e1
where e1.rank=2;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is bind variable in pl sql?

1056

what are the different functions in sorting an array? : Sql dba

1027

What is cartesian join in sql?

1135

define sql update statement ? : Sql dba

1124

What is acid property in a database?

1035

What are sql ddl commands?

1097

Does truncate release storage space?

1082

What are the dml statements?

1143

Why stored procedures are faster than query?

1029

How does sql*loader handles newline characters in a record? : aql loader

1047

How many tables can you join in sql?

958

What is trigger with example?

1104

How to find 3rd highest salary of an employee from the employee table in sql?

1083

How do you write an index?

971

Why do we need unique key in a table?

960