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

how to get second highest salary in SQL(as/4000

Question Posted / deepak

29 Answers
32985 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / deepak

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

Is This Answer Correct ?

12 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is dml statement?

1001

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4097

What is foreign key in sql with example?

975

What is data manipulation language?

1232

Explain foreign key in sql?

1083

How to prepare for oracle pl sql certification?

1109

How does postgresql compare to "nosql"?

1086

How much ram can sql express use?

1041

what are the 'mysql' command line arguments? : Sql dba

1192

What are different types of sql commands?

1203

What program will open a mdb file?

1020

What is the difference between null value, zero, and blank space?

1255

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1273

What are the different sql languages?

1093

Which is faster truncate or drop?

1101