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
32116 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

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

997

What is a table in a database?

1043

What is procedure explain with program?

1015

Is time a data type in sql?

901

What is dbo in sql?

954

What is database white box testing and black box testing?

1107

Can delete statement be rollbacked?

984

what is auto increment? : Sql dba

1004

Why functions are used in sql?

988

what is the difference between $message and $$message? : Sql dba

995

Why do we use sqlite?

967

what is a constraint? : Sql dba

1157

What is the difference between unique and primary key constraints?

1068

What is the file extension for sql database?

997

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2277