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;

Can %notfound return null after a fetch?

0 Answers  

How to take user input in pl sql?

0 Answers  

What is the difference between Union and Union all. Which is faster.

0 Answers  

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

What is blind sql injection?

0 Answers  

How to maintain the history of code changes of pl/sql?

3 Answers  

Difference between a query and strored procedure?

4 Answers   Microsoft,

What is trigger in pl sql with examples?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

What are the parameter modes supported by pl/sql?

0 Answers  

Can we insert in sql function?

0 Answers  

What is exit statement?

0 Answers