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

Answer Posted / deepak

Is This Answer Correct ?

12 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How do you update f as m and m as f from the below table testtable?

1791

How do you identify a primary key?

1013

How do I trace sql profiler?

923

What is before trigger?

948

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1035

Can we use joins in subquery?

1089

What can sql server reporting services do?

1057

Where is sql database stored?

921

What is the requirement of self-join?

1027

What is sql integrity?

1064

Is sql injection illegal?

963

How does sql*loader handles newline characters in a record? : aql loader

987

Why do we create views in sql?

1055

How do you sort in sql?

954

What are the string functions in sql?

925