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

how to find out second largest value in the table

Question Posted / karthik

Answer Posted / karthik

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the use of consistent option in exp command.

1066

Describe the types of sub query?

993

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

1899

How do I uninstall oracle client from windows?

1010

How to define an anonymous procedure without variables?

1104

What is a schema in oracle?

1012

What is catalog in Oracle?

1363

Explain oracle insert into command?

1110

What is the disadvantage of User defind function?

2290

How to get execution statistics reports on query statements?

1090

What is rowid and rownum in oracle?

1011

How to view existing locks on the database?

1053

What is the sid in oracle?

963

State and explain the different types of data models?

940

How to define an anonymous block?

1154