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

What is java sql driver?

1037

What is the use of desc in sql?

913

What is procedure and function in sql?

927

How do sql triggers work?

984

What is compound trigger?

958

How do you change a value in sql?

964

What is normalization sql?

994

What are the types of views in sql?

1038

What are predefined functions in sql?

976

What is a composite primary key?

1030

How delete all data from all tables in sql?

882

What are the advantages of pl sql?

1070

What is trigger in sql?

1026

How to change the order of columns in Oracle SQL Plus ?

992

how can we know the number of days between two given dates using mysql? : Sql dba

990