Select sal from emp a where 2=(select count(distinct sal) from emp b wher

1.how to extract the second highest salary from emp table
having sal as a column which contains the salary of all
employee of an organisation.

Question Posted / hema

Answer Posted / hema

Select sal from emp a where 2=(select count(distinct sal)
from emp b where a.sal <= b.sal)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Please explain drop constraint oracle?

1056

How translate command is different from replace?

1037

How to view the data files in the current database?

1056

How to check your oracle database 10g xe installation?

954

What privilege is needed for a user to create tables in oracle?

922

What is a nested table and how is it different from a normal table?

1006

In which language oracle has been developed?

1033

What is the usage of merge statement?

1109

What is a table in oracle?

951

How does one get the view definition of fixed views/tables?

979

How to concatenate two text values in oracle?

1077

How does the on-delete-cascade statement work?

1072

Is oracle a programming language?

955

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1868

What are the ways tablespaces can be managed and how do they differ?

2301