Answer / udaya

select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)

Answer / neetu

Select Top 1 Salary from TableName where Salary IN(select
top 3 salary from TableName order by salary Desc) order by Asc

Answer / cpnagar

select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary

Answer / kk

select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Answer / rajasekar

er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc

Answer / cpnagar

SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3

Answer / karthik

select min(salary) from (select top 3 * from employee order by salary desc) temp

Answer / vasanth

SELECT min(Salary)
FROM (SELECT TOP 3 Salary FROM dbo.tblPopulation
GROUP BY [Population (in Millions)]
ORDER BY [Population (in Millions)] DESC ) TEMP

Answer / vaishnavi nigam

SELECT Salary from Emp_sal ORDER BY Salary Desc WHERE Row_Num=3

Answer / shruti

select salary from salarytable orderby salary desc Limit 2,1

First It will arrange all salary in desc order then it will
limit the result using Limit command starting from position
0,1,2 and fetch record 1

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

How to get number of days in a given year?

4 Answers   ADP,

What is the difference between functions and stored procedures?

0 Answers   Accenture,

Describe in brief sql server monitoring ways.

0 Answers  

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

What are the properties of primary key?

0 Answers  

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

How to delete an existing database user?

0 Answers  

What is simple indexing method?

0 Answers  

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

Explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

what is diffence between replicaion and logshipping?

1 Answers