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 blocking and how would you troubleshoot it? : sql server database administration
Can you please differentiate between a primary key and a unique key?
What is the difference between a clustered index and a non-clustered index?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is difference between Datepart() and Datename() in SqlServer?
What are the various Isolation levels?
how to insert the values in 5 table at a time with triggers . if u have any solution then co-operate me ?
What is indexed view? How to create it?
What is difference statement and preparedstatement?
Explain log shipping?
Write a SQL query to make a column as unique?
What is the use of nvl work?