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

What is the difference between a subquery and a join?

1109

What is secondary key?

934

Is sql injection illegal?

1025

What can I use instead of union in sql?

967

What is sql injection owasp?

1066

What is raid? How does it help storage of databases?

1087

What does the sign mean in sql?

990

What is union, minus and interact commands?

1299

What is mutating error?

968

Which join is like an inner join?

1028

What are the types of optimization?

961

What are the different types of sql commands?

1128

How does one use sql*loader to load images, sound clips and documents? : aql loader

1187

what is a join? : Sql dba

1037

how do you know the version of your mysql server? : Sql dba

1004