select rank,sal from(select rownum rank,distinct(sal) from emp order by s

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

Question Posted / dilip

Answer Posted / dilip

select rank,sal from(select rownum rank,distinct(sal) from
emp order by sal desc)
where rank=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does subquery mean in sql?

1114

What is using in sql?

1142

what is the difference between sql and t-sql? : Transact sql

1136

What is an intersect?

1156

What is sql in java?

1134

How many rows can sqlite handle?

1163

Is sql a backend?

1073

What is pivot in sql?

974

What is the difference between numeric and autonumber?

1041

what is a record in a database ? : Sql dba

1105

Is there a 64 bit version of ssms?

1000

What is the best sql course?

1028

How do you define a foreign key?

1067

how mysql optimizes distinct? : Sql dba

1125

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1052