select MAX (sallary) from emp where sallary<=(select MAX(sallary) from e

how to find the second highest salary from emp table?

Question Posted / amol

Answer Posted / amol

select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How show all rows in sql?

1011

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1036

What is sqlservr exe?

973

What are sql data types?

1019

How many triggers can be applied on a table?

930

what is self-join? : Sql dba

1155

is it possible to pass an object or table to a procedure as an argument?

1127

What are sql*plus environment variables?

1093

What is compute?

1082

What are the syntax and use of the coalesce function?

1198

explain advantages of innodb over myisam. : Sql dba

1126

How to rename a table?

1010

What is sqlexception in java?

984

Inline the values in PL/SQL, what does it mean.?

1221

What does truncate mean in sql?

1019