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 to delete existing triggers using "drop trigger"?

0 Answers  

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

What is the difference between login and a user?

13 Answers   CTS, TCS,

What is tablesample?

0 Answers  

How to concatenate two binary strings together?

0 Answers  

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

Can we use custom code in ssrs?

0 Answers  

What is normalization 1nf 2nf 3nf?

0 Answers  

What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,