second method is select sal from emp e1 where 2=(select count(distinct(sal

how to find the second highest salary from emp table?

Question Posted / radha sri seshu

Answer Posted / radha sri seshu

second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);

Is This Answer Correct ?

35 Yes

22 No

Please Help Members By Posting Answers For Below Questions

What are %type and %rowtype for?

1109

What is a composite primary key?

1142

Which data type is a composite type?

1037

What is the difference between function, procedure and package in pl/sql?

1355

What is update query?

1035

What is record data type?

981

what are dynamic queries in t-sql? : Transact sql

1070

What is a temporal table?

983

what is a composite primary key ? : Sql dba

1095

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

1035

Can we use pl sql in sql server?

1136

What is a unique key?

1106

What is recursive stored procedure?

1142

how to analyze tables with 'mysqlcheck'? : Sql dba

1062

What is the main difference between sql and pl/sql?

1150