Select Sal From Emp A WHERE 1=(Select Count(Sal) From Emp B WHE

Query to get max and second max in oracle in one query ?

Question Posted / purna chowdary

Answer Posted / purna chowdary

Select Sal From Emp A
WHERE 1=(Select Count(Sal) From Emp B
WHERE B.Sal>A.sal)
GROUP By Sal Desc

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is Redo Log Buffer in Oracle?

1127

What are the execution control statements?

1018

What is define in oracle?

999

How to use in conditions in oracle?

998

How to convert raw data type into text in oracle? Explain

953

What is connection pooling in oracle?

914

What is oracle analytical function?

1032

How to use "startup" command to start default instance?

962

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2068

What is bulk collect in oracle?

958

How to view the tablespaces in the current database?

929

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2075

Explain the importance of .pll extension in oracle?

956

How to do paging with oracle?

950

Explain the truncate in oracle?

914