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)

how can ur insert the emp table

3 Answers   Wipro,

difference between Clustered index and non clustered index ?

0 Answers   Infosys,

What is Schema in Database?

1 Answers   Cap Gemini,

Explain what role entity and relationship play in an ER diagram.

0 Answers  

Explain the advantages of merge replication?

0 Answers  

What are subqueries in sql server? Explain its properties.

0 Answers  

Define tempdb database?

0 Answers  

What is the use of MOVE keyword in restore command

3 Answers   IBM,

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

0 Answers  

What are the pros and cons of creating extended stored procedures?

1 Answers  

What is “asynchronous” communication in sql server service broker?

0 Answers  

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers