SELECT DISTINCT(E.SALARY) FROM EMPLOYEES E WHERE 2=(SELECT COUNT(DISTINCT D

how to find the second highest salary from emp table?

Question Posted / shankar panda

Answer Posted / shankar panda

SELECT DISTINCT(E.SALARY) FROM EMPLOYEES E WHERE 2=(SELECT COUNT(DISTINCT D.SALARY) FROM EMPLOYEE D WHERE D.SALARY >= E.SALARY)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3570

Can we rename a column in the output of sql query?

995

What is crud sql?

988

what is text? : Sql dba

1073

What is varchar sql?

1146

What is trigger and stored procedure in sql?

1037

What is the primary key?

952

what is the syntax for using sql_variant_property? : Transact sql

1047

What is thread join () in threading?

1016

Explain about various levels of constraint.

949

What is rank function in sql?

1029

What does the sign mean in sql?

990

Which operator is used in query for pattern matching?

1089

How do I order by ascending in sql?

1024

What are the different types of sql commands?

1128