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

Explian rowid, rownum? What are the psoducolumns we have?

984

how to get @@error and @@rowcount at the same time? : Sql dba

1007

What is meant by cursor in sql?

972

What are local and global variables and their differences?

1075

Why is sharding used?

978

Is progress software supports to ( pl/sql )?

1021

How do I partition a table in sql?

1101

Should I use mbr or gpt?

1010

How can I make sql query run faster?

996

Is pl sql a scripting language?

1012

Is trigger a stored procedure?

921

How to pipe multiline string to isql?

998

what is 'mysqld'? : Sql dba

955

How do you use join?

920

What version is sql?

1005