select max(sal) from emp where sal<(select max(sal) from emp where sal&l

how to check the 3rd max salary from an employee table?

Question Posted / srinivas

Answer Posted / srinivas

select max(sal) from emp where sal<(select max(sal) from emp where sal<(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Are subqueries better than joins?

922

what are the t string functions available in tsql? : Transact sql

947

Can triggers stop a dml statement from executing on a table?

1026

What is difference between hql and sql?

992

How does pl sql work?

915

What is exception? What are the types of exceptions?

1034

Can we insert in view in sql?

1004

What is difference between inner join and cross join?

912

Who is the owner of mysql database?

1002

What is sql*loader?

1076

What are variables in pl sql?

1094

What is record data type?

861

What is the starting oracle error number? What is meant by forward declaration in functions?

940

What is the difference between subquery and correlated query?

991

What are reports usually used for?

968