How to Select second Maximum salary in a Table ?

Question Posted / subbareddy

13 Answers
16155 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

What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?

1 Answers

What are the factors causing the reparsing of SQL statements in SGA?

2 Answers

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers iFlex,

What is a trace file and how is it created in oracle?

0 Answers

What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?

1 Answers

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 Answers

What privilege is needed for a user to query tables in another schema?

0 Answers

Explain the use of rows option in exp command.

0 Answers

Is there an oracle sql query that aggregates multiple rows into one row?

0 Answers

What is oracle update statement with inner join ?

0 Answers

How to define an anonymous procedure with variables?

0 Answers

What is Database Link ?