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 save transaction and save point?

0 Answers  

What is the use of builtinadministrators group in sql server? : sql server security

0 Answers  

How do I create a partition table in sql server?

0 Answers  

Explain contrast amongst grouped and non-bunched records?

0 Answers  

How to test values returned by a subquery with the in operator?

0 Answers  

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

Can a function call a stored procedure in sql server?

0 Answers  

What is a trigger in sql server?

0 Answers  

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

0 Answers   Value Labs,

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

0 Answers  

what is denormalization and when would you go for it? : Sql server database administration

0 Answers