Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where

how to find the second highest salary from emp table?

Question Posted / jyotiprokash

Answer Posted / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is sql in mysql? : Sql dba

1238

How to fix oracle error ora-00942: table or view does not exist

1084

Which kind of parameters cannot have a default value in pl sql?

1213

explain the difference between delete , truncate and drop commands? : Sql dba

1147

Show how functions and procedures are called in a pl/sql block.

1188

What is snowflake sql?

1130

Is pl sql a programming language?

1045

How many joins in sql?

1059

who introduced sql?

1074

Why do you partition data?

1066

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1136

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

1930

What are types of indexes in sql?

1137

Explain the difference between triggers and constraints?

1025

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1185