select distinct (a.sal) from emp a where &n = (select count (distinct(

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / reddy

Answer Posted / reddy

select distinct (a.sal) from emp a where &n = (select count
(distinct(b.sal) from emp bmwhere a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is truncate ddl or dml?

1038

What are the different types of functions in sql?

1098

What is information schema in sql?

1113

what is sql server agent? : Sql dba

1158

Explain the uses of control file.

1099

Why do we use cursors?

1043

What are sql functions? Describe in brief different types of sql functions?

1179

Define union, minus, union all, intersect ?

1064

explain about mysql and its features. : Sql dba

1052

What is query execution plan in sql?

1247

What is set serveroutput on in pl sql?

1359

what are numeric data types? : Sql dba

1111

What is embedded sql what are its advantages?

1108

What is difference between stored procedures and application procedures?

1063

what is the difference between nested subquery and correlated subquery?

1091