select (distinct(a.sal) from emp e where rownum=&N(select count(distin

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

Question Posted / om patel

Answer Posted / om patel

select (distinct(a.sal) from emp e where rownum=&N(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do you explain an index number?

1188

How do I remove duplicates in two columns?

1150

Why coalesce is used in sql?

1069

What is sap sql anywhere?

1169

What are different types of statements supported by sql?

1212

what are tables and fields? : Sql dba

1105

what are the differences among rownum, rank and dense_rank? : Sql dba

1087

what are numeric data types? : Sql dba

1111

how to use in conditions? : Sql dba

1063

Can we call procedure in select statement?

1113

Can we use the cursor's to create the collection in PL/SQL?

1096

What is meant by temporal data?

1005

what is a relationship and what are they? : Sql dba

1166

What is sql lookup?

974

What are the most important characteristics of pl/sql?

1229