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

How to get second highest salary from a table

Question Posted / senthil

Answer Posted / senthil

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is pragma in sql?

1022

How do I run a script in sql developer?

901

What are system versioned tables?

969

Is join an inner join?

897

Is nosql relational?

895

What are character functions?

1042

What is the usage of distinct keyword?

1020

What are the string functions in sql?

925

what are the differences between char and nchar? : Sql dba

1056

What is optimistic concurrency control? : Transact sql

944

What is the basic form of sql query?

881

what are the different type of normalization? : Sql dba

973

How to return multiple rows from the stored procedure?

916

What is a null value?

1089

What is informix sql?

924