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)

Different types of keys in SQL?

0 Answers   Infosys,

What is difference between inner join and full join?

0 Answers  

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

What is the difference between join and inner join?

0 Answers  

What are data resources?

0 Answers  

What is extended stored procedures?

0 Answers  

what is a self join? : Sql server database administration

0 Answers  

What is the default value of an integer data type in sql server 2005?

0 Answers  

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  

What is xdr?

0 Answers  

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers