write query for fourth maximum salary from employee table
Answers were Sorted based on User's Feedback
Answer / ilgian
select min(salary)
from (
select top 4 *
from employees
order by salary desc
) as a
Is This Answer Correct ? | 24 Yes | 7 No |
Answer / arun kumar
select top 1 e.emp_code,e.emp_name,ed.basic_salary from
employee_master e, employee_salary_detail ed where
e.emp_id=ed.emp_id order by basic_salary desc
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / anish tuladhar
select
distinct salary
from
(
select
DENSE_RANK() over(order by salary desc) as rnk,
modelyr_id_int
from
employee
) a
where
rnk = 4
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raman
select top 1(esal) from (select top 2(esal) from employee order by esal desc) employee order by esal asc
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajay roy
The Correct answer is ---
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Thanks Elumalai.k
Top Keyword returns the top(first) row not the max record
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / yogendra barode
Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc
Is This Answer Correct ? | 5 Yes | 5 No |
Answer / dharmendra k. dixit
For Finding Nth Salary...
SELECT TOP 1 Salary FROM
(SELECT TOP nth Salary FROM Table Order by Salary Desc)Table
As Sal Order by Salary
Is This Answer Correct ? | 5 Yes | 5 No |
select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)
Is This Answer Correct ? | 4 Yes | 4 No |
Answer / avanish kumar
if you have a table emp and you have to find fourth maximum
salary from emp table then you will have to write this
query.....
select top 1 sal from (select top 4 * from emp order by sal
desc) as sal order by sal
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / pramod
Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc
Is This Answer Correct ? | 1 Yes | 1 No |
What is sleeping status in sql server?
Explain the working of sql privileges?
Which stored procedure will you be running to add a linked server?
Explain rdbms?
What is difference between drop truncate and delete?
What are the restrictions applicable while creating views? : SQL Server Architecture
How to convert numeric expression data types using the cast() function?
How to use clusters?
what is difference between having and where clause ?
What are the different SQL Server Versions you have worked on?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is a DBMS, query, SQL?