How to Select second Maximum salary in a Table ?

Question Posted / subbareddy

13 Answers
15782 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to Select second Maximum salary in a Table ?..

Answer / 9896012055

select * salary from table < select max(salary) from table
order by salary;

Is This Answer Correct ?

0 Yes

4 No

How to Select second Maximum salary in a Table ?..

Answer / a.swarna devi

select max(sal)from table;

Is This Answer Correct ?

2 Yes

13 No

How to Select second Maximum salary in a Table ?..

Answer / havyas

select sal from table where rownum = 2 order by sal desc

Is This Answer Correct ?

1 Yes

13 No

Post New Answer

More Oracle General Interview Questions

How to use attributes of the implicit cursor in oracle?

0 Answers

What are triggers?Where are they used?

3 Answers

Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers IBM,

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers IBM,

What are the sql clauses supported in the link property sheet ?

1 Answers Oracle,

Explain an exception?

0 Answers

can u plz provide me oca sql dumps please i need them

0 Answers

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

0 Answers

how to get the index id?

1 Answers Cognizant, TCS,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers

Whatz the main diff between Subquery and a Join

14 Answers Oracle, Zeta Interactive,

How to create a stored procedure in oracle?

0 Answers

For more Oracle General Interview Questions Click Here