select max(sal) from emp where sal!=(select max(sal) from emp)

how to find the second highest salary from emp table?

Question Posted / boring guy

Answer Posted / boring guy

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

how many ways we can we find the current date using mysql? : Sql dba

1102

Is id a reserved word in sql?

1151

What is sql*loader?

1200

What is group by in sql?

1089

What is auto increment?

1008

What is a pl/sql block?

1236

Is sql database free?

983

What is the purpose of a sql?

977

What is the usage of sql functions?

1150

List the various privileges that a user can grant to another user?

1047

what is the use of friend function? : Sql dba

1023

what is rdbms? : Sql dba

1018

Does mysql_real_escape_string prevent sql injection?

955

What are the disadvantages of not performing database normalization?

1168

What are stuff and replace function?

1091