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 group function in sql?

1067

what is schema? : Sql dba

1113

How to write pl sql program in mysql command prompt?

1165

Is sql database free?

1024

Which query operators in sql is used for pattern matching?

1011

What is difference between stored procedure and trigger?

1251

Explain what is an index?

1104

What are different types of indexes?

1056

What is rownum in sql?

1093

Can we join two tables without common column?

1060

how to enter characters as hex numbers? : Sql dba

1102

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1055

What is #table in sql?

1182

Can a select statement fire a trigger?

1209

What types of commands can be executed in sql*plus?

1163