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 update query?

984

What are pl/sql cursors?

1050

Is vs as in pl sql?

987

What is output spooling in sql*plus?

1036

what is a tablespace? : Sql dba

1053

How many subqueries can be nested in a statement?

986

How can I get the number of records affected by a stored procedure?

1066

is it possible to pass an object or table to a procedure as an argument?

1135

how to write date and time literals? : Sql dba

962

What is a stored procedure in sql with example?

1132

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

Is oracel sql developer written in java?

1108

What is %type in sql?

969

how to create a new view in mysql? : Sql dba

938

What is java sql connection?

1061