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)

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

What guidelines should be followed to help minimize deadlocks?

0 Answers  

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

0 Answers  

what stored procedure would you use to view lock information? : Sql server administration

0 Answers  

What is the significance of master, tempdb and model databases?

0 Answers  

What is cte (common table expression)?

0 Answers  

What are the various Isolation levels?

2 Answers   HP,

What is ms sql server reporting services?

0 Answers  

What are null values in ms sql server?

0 Answers  

Where are sql server user names and passwords stored in sql server?

0 Answers  

Define full outer join in sql server joins?

0 Answers  

How to retrieve error messages using odbc_errormsg()?

0 Answers