select distinct(a.sal) from emp a where 2=(select count(distinct(b.sal)) fr

Query for second maximum salary in each in each department

Question Posted / sampath pallerla

Answer Posted / sampath pallerla

select distinct(a.sal) from emp a where 2=(select count(distinct(b.sal)) from emp b where a.sal<=b.sal);

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

what are all types of user defined functions? : Sql dba

1042

Write an sql query to select all records from the table?

1023

Is it possible to pass parameters to triggers?

1099

Differentiate between % rowtype and type record.

1293

Explain what is a database?

1082

What is the location of pre_defined_functions.

1162

Define the select into statement.

1046

What is the primary key?

949

What is sql engine in oracle?

985

What is rank function in sql?

1022

how to use in conditions? : Sql dba

1009

Where can I learn sql for free?

981

Is sql considered coding?

1043

What is the difference between an inner and outer join?

1010

What is a primary key? Explain

972