Answer / saravakumar

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Answer / answer

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 MAX (SALARY) FROM EMPLOYEE ORDER BY SALARY
DESC)

Answer / rahul gupta

select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)

Answer / lince thomas

select salary from(
select row_number() over(order by salary desc) as rno,*
from Employee)T where T.rno=6

Answer / lince

select * from(select salary,dense_rank() over(order by salary desc) as rno from emp)T where T.rno=6

Answer / anto

select distinct top6 salary from employee

Answer / vj

with cte as
(
select dense_rank() over (order by salary desc)
maxSal ,* from Employee )
select * from cte where maxSal=6

Answer / maheswar reddy s

select * from Employee e1 where 6=(select count(distinct(salary))from employee e2 where
e2.salary>=e1.salary)

Answer / krishan kant

SELECT MIN(SALARY) FROM EMPLOYEE WHERE SALARY IN (SELECT
DISTINCT TOP 6 SALARY FROM EMPLOYEE ORDER BY SALARY
DESC)

Answer / manikanta

select min(salary) as salary from Employee where salary >
(select min(salary)from employee)

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

How will you know when statistics on a table are obsolete?

0 Answers  

Explain about SQLOS?

0 Answers  

how to change column into row in sql

4 Answers   ESS,

Can I delete event logs?

0 Answers  

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

what are file groups?

3 Answers   Evalueserve,

What is the simplest way to create a new database in ms sql server?

0 Answers  

What is extent? Types of extents?

0 Answers  

What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,

What is the default order of an order by clause?

0 Answers  

What is co-related sub query?

0 Answers