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;

How to get each name only once from an employee table?

0 Answers  

how do you login to mysql using unix shell? : Sql dba

0 Answers  

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

What are literals in sql server?

0 Answers  

What does <> sql mean?

0 Answers  

what is query cache in mysql? : Sql dba

0 Answers  

How do I clear the screen in sql plus?

0 Answers  

scope of exception handling in plsql

4 Answers   Wipro,

Which is faster subquery or join?

0 Answers  

What are different sql data types?

0 Answers  

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

Can we change the table name in sql?

0 Answers