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

What is the command used to fetch first 5 characters of the string?

1392

can a stored procedure call itself or recursive stored procedure? : Sql dba

1026

how would concatenate strings in mysql? : Sql dba

1086

What is out parameter used for eventhough return statement can also be used in pl/sql?

1069

explain advantages of innodb over myisam. : Sql dba

1125

what is subquery? : Sql dba

1126

Is sql database free?

968

Why query optimization is needed?

921

What is form and report?

972

what is the difference between undefined value and null value? : Sql dba

1096

What is count * in sql?

993

What is a column in a table?

1118

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1144

what is blob? : Sql dba

1143

what is the difference between nested subquery and correlated subquery?

1049