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

how to find the second highest salary from emp table?

Question Posted / jhansi

Answer Posted / jhansi

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many row comparison operators are used while working with a subquery?

1030

How to pipe multiline string to isql?

1007

How do you run a query?

990

what is the difference between myisam static and myisam dynamic? : Sql dba

1066

How do I run a sql trace?

960

Why use stored procedures?

1094

Compare sql & pl/sql

1142

What is replication id?

938

What are different types of statements supported by sql?

1165

What is the largest value that can be stored in a byte data field?

1012

Where is pl sql used?

954

what are the different type of normalization? : Sql dba

1027

What is sql performance tuning?

921

what is heap table? : Sql dba

1106

What is primary key in db?

1011