select A.* from employee A where 1=(select count(distinct B.sal) from empl

how to find the second highest salary from emp table?

Question Posted / prasanna

Answer Posted / prasanna

select A.* from employee A where 1=(select count(distinct
B.sal) from employee B where B.sal>A.sal)

Is This Answer Correct ?

63 Yes

71 No

Please Help Members By Posting Answers For Below Questions

Is sql scripting language?

1113

What is range partitioning?

1014

What are string functions in sql?

1302

What is sql table?

1022

How do I get sql certification?

1017

Explain polymorphism in pl/sql.

1171

Differentiate between sga and pga.

1206

how many tables will create when we create table, what are they? : Sql dba

1114

What is difference between table and view?

1134

Can we use ddl statements in stored procedure?

1190

What is sql partition?

1162

How do I run pl sql in sql developer?

1170

Is it important to partition hard disk?

1067

What is the purpose of the sql select top clause?

1203

Which is faster view or stored procedure?

1009