select distinct sal from emp e where 2=(select count(distinct sal)from emp

how to find the second highest salary from emp table?

Question Posted / sankar sasmal

Answer Posted / sankar sasmal

select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is insert command in sql?

1140

What is db journal file?

1074

Is it important to partition hard disk?

1036

What is bitemporal narrowing?

1318

What is procedure and function in sql?

1003

What is bind variable in pl sql?

1066

How will you distinguish a global variable with a local variable in pl/sql?

1161

How do I edit a stored procedure?

1008

What is compiled query?

1045

Why stored procedure is faster than query?

1076

What is the difference between local variables and global variables?

1131

What is the use of pl/sql table?

1075

How to avoid using cursors?

1132

Explain select statements in sql?

1067

how to escape special characters in sql statements? : Sql dba

1049