Answer / abc

Select salary from (select salary from employees order by
salary desc) where rownum <=2;

Answer / rajkumar

select top 1 colmn from table_name where colmn in
(select top 2 colmn from table_name where colmn is not
null order by colmn desc)

Answer / arun

select salary from(select salary from(select distinct salary from employees order by salary desc) where rownum<=2 order by salary) where rownum=1;

Answer / srinivas

select * from emp m
where
(select count(distinct sal)+1 from emp s
where s.sal>m.sal)<=2
order by sal desc

Answer / mamta

Select sal
from salary_tbl
where rownum <= 2
order by sal desc;

Answer / anusreekr

An error is occuring saying "unknown column rownum".
Please let me know where rownum feature is available in all
the mysql versions.The server version i am using is 5.5.21.

Thanks

Answer / unknown

Select salary from (select salary from employees) where
rownum <=2;

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

What is the basic structure of PL/SQL ?

6 Answers  

what does myisamchk do? : Sql dba

0 Answers  

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

What is the difference between cluster and non-cluster index?

0 Answers  

Difference between SUBSTR and INSTR?

3 Answers  

diff b/w sub query and co-relater query?

3 Answers   iFlex,

What are the set operators in sql?

0 Answers  

What are the different types of constraints?

0 Answers  

25.67,-1 Trunc = 20 Round= 30 HOW????

2 Answers   Karrox,

What is nvl function?

4 Answers   Cap Gemini,

What is difference between left and right outer join?

0 Answers