select max(sal) from employee where sal not in(select max(sal) from employ

how to find the second highest salary from emp table?

Question Posted / vikas naik

Answer Posted / vikas naik

select max(sal) from employee where sal not in(select
max(sal) from employee);

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What does (+) mean in sql joins?

1007

How is use pl and sql?

1000

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

904

what are the different index configurations a table can have? : Sql dba

936

What is the purpose of the primary key?

1004

What are all the common sql functions?

968

Which query operators in sql is used for pattern matching?

901

What is clustered and nonclustered index in sql?

889

Is sqlite thread safe?

990

Why do we need cursor in pl sql?

1078

How to look at the current sql*plus system settings?

1077

what is text? : Sql dba

1006

What is the difference between subquery and correlated query?

986

What does sign mean sql?

1019

How to handle bulk data?

1267