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;

Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  

what is a constraint? : Sql dba

0 Answers  

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

Why do we need view in sql?

0 Answers  

suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??

5 Answers   Keane India Ltd,

How do you create a unique index?

0 Answers  

What is sql used for?

0 Answers  

Which is better join or inner query?

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

Can sql function call stored procedure?

0 Answers  

What is $$ in sql?

0 Answers  

Why does %isopen return false for an implicit cursor?

1 Answers