select sal from emp_sal where rownum = 3 order by sal desc

how to check the 3rd max salary from an employee table?

Question Posted / manish_patil

Answer Posted / manish_patil

Is This Answer Correct ?

6 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Can you selectively load only those records that you need? : aql loader

986

Why do we use sqlite?

919

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

Can we enter data in a table in design view?

913

What is mdb stand for?

961

Explain the structure of pl/sql in brief.

1044

Does normalization improve performance?

982

How to pronounce postgresql?

1009

How many types of keys are there in sql?

988

How do you drop a trigger?

924

How do I quit sql?

900

How do you determine the current isolation level? : Transact sql

1074

What is t-sql? : Transact sql

928

Can you have more than one key in a database?

893

Which version of sql do I have?

1000