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 kind of join is join?

905

When you have to use a default "rollback to" savepoint of plvlog?

1125

How does cross join work?

877

How do I view tables in mysql?

917

what is user defined functions? : Sql dba

977

What is cartesian join in sql?

1030

how to fetch common records from two tables? : Sql dba

1108

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

960

What is the use of sqlerrd 3?

890

How to run sql functions in pl/sql?

992

how to drop an existing view in mysql? : Sql dba

997

what is single byte over head in oracle..?

2342

What are analytic functions in sql?

972

How do you update a table in sql?

929

What is function and procedure in pl sql?

975