1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Find out the 3rd highest salary?

Question Posted / guest

Answers were Sorted based on User's Feedback



Find out the 3rd highest salary?..

Answer / xxx

select ename, salary from
(Select ename, salary, rownum
FROM emp where rownum<=3
Order by salary )
where rownum = 1
;

Is This Answer Correct ?    7 Yes 20 No

Post New Answer

More SQL PLSQL Interview Questions

what are null values? : Sql dba

0 Answers  

What are sql constraints?

0 Answers  

what is 'mysqld'? : Sql dba

0 Answers  

Which version of sql do I have?

0 Answers  

What do you think about pl/sql?

0 Answers  




how u can find the n row from a table?

19 Answers   Tech Mahindra,

what is the difference between trigger and constraint?

3 Answers   HSBC,

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

How many parts of a pl sql block are optional?

0 Answers  

What are basic techniques of indexing?

0 Answers  

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

23 Answers   IBM,

Which is faster union or join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories