select * from empdetails where sal=(select max(sal) from empdetails where

find out the second highest salary?

Question Posted / aravind

Answer Posted / aravind

select * from empdetails where sal=(select max(sal) from
empdetails where sal<(select max(sal)from empdetails));

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to define and use table alias names in oracle?

989

What is using clause and give example?

1108

How to pass parameters to procedures in oracle?

1082

How to write an inner join with the where clause in oracle?

1090

what are the advantages of running a database in archive log mode?

2255

How to create a table interactively?

1166

What are the different types of record groups in oracle? Explain each of them

1070

Why cursor variables are easier to use than cursors?

1139

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2368

What is object data modeling?

1017

What is hot backup and logical backup?

1112

How will you identify oracle database software release?

1058

How to convert a string to a date in oracle database?

1100

How to add another datafile to a tablespace?

1089

What are the differences between blob and clob in oracle?

1135