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

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

0 Answers  

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

How to run queries with sql server management studio express?

0 Answers  

Why variables called the most powerful component of ssis?

0 Answers  

how many layers of tcp/ip protocol combined of? : Sql server database administration

0 Answers  

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

What is correlated subquery in sql server?

0 Answers  

What do you understand by the data quality services in sql server?

0 Answers  

How to verify a user name with sqlcmd tool?

0 Answers  

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

Explain Capacity planning to create a database? and how to monitor it?

0 Answers