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

how to find the second highest salary from emp table?

Question Posted / ramcharan tej

Answer Posted / ramcharan tej

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is microsoft t sql?

942

Can a composite key be null?

974

What is the purpose of cursors in pl/sql?

1134

how do you login to mysql using unix shell? : Sql dba

1079

what are the limitations of identity column? : Transact sql

1106

What are the qualities of 2nf?

1037

What do you mean by field in sql?

1077

What does count (*) mean in sql?

1583

How do I trace sql profiler?

971

What is use of package in pl sql?

1011

How do I turn a list into a table?

958

What is a rank in sql?

960

What is raw datatype in sql?

1042

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

991

What are the different ways to optimize a sql query?

946