find the 3rd max salary
Answers were Sorted based on User's Feedback
Answer / udaya
select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)
Is This Answer Correct ? | 11 Yes | 3 No |
Answer / neetu
Select Top 1 Salary from TableName where Salary IN(select
top 3 salary from TableName order by salary Desc) order by Asc
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / cpnagar
select top 1 salary from(select distinct top 3 salary from
emp order by salary desc)as e order by e.salary
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / kk
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajasekar
er
# 9
select top 1 * from (
SELECT DISTINCT TOP 3 salary
FROM tblemp
ORDER BY salary desc) t order by salary asc
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / cpnagar
SELECT salary FROM (SELECT ROW_NUMBER() OVER (ORDER BY
salary desc) AS RN,*
FROM
emp)temp
WHERE
RN=3
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / karthik
select min(salary) from (select top 3 * from employee order by salary desc) temp
Is This Answer Correct ? | 0 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vaishnavi nigam
SELECT Salary from Emp_sal ORDER BY Salary Desc WHERE Row_Num=3
Is This Answer Correct ? | 0 Yes | 1 No |
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
Is This Answer Correct ? | 0 Yes | 2 No |
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
What are the requirements for sql server 2016?
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
What is schemabinding a view?
What is single-user mode?
what are defaults? : Sql server database administration
What is the difference between having and where clause?
What are cursors? Name four types of cursors and when each one would be applied?
How to use subqueries with the in operators in ms sql server?
What is change data capture (cdc) feature?
What is SQL server agent?
How to write a query with a left outer join in ms sql server?