How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answers were Sorted based on User's Feedback
Answer / yogesh
A little correction:
sol2> select salary from emp order by salary desc limit 1,1;
select salary from emp order by salary desc limit n-1,1;
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / riyazkhan
select Sal from Employee where Sal != (select max(Sal) from Employee) Order By Sal desc
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ranjith
Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / veerdhawal
mysql> select max(sal) from emp where sal not in (select
max(sal) from emp);
+----------+
| max(sal) |
+----------+
| 30000 |
+----------+
1 row in set (0.01 sec)
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ravi kumar
SELECT MIN(sal) FROM Emp WHERE sal in
(SELECT TOP 2 DISTINCT sal from Emp ORDER BY DESC)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / harsha
select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bobby
select p.emp_id,p.name,p.salary from
( select emp_id,name,salary,dense_rank()over( order by
salary desc)rank
from empTable )p
where rank=2
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sandee saxena
-- Create table #temp
-- (
-- Emp_id int identity(1,1),
-- Emp_Name varchar (100) ,
-- Emp_Salary int
-- )
--
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('kunal', '2000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('aditya', '5000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('abhishek', '6000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('kailash', '5000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('rohit', '8000')
-- Insert into #Temp (Emp_Name, Emp_Salary) values
('rakesh', '3000')
Select a.* From #temp a,
(Select Max(a.Emp_salary)Emp_Salary From #temp a,
(Select Max(x.Emp_salary)Emp_Salary From #temp a,
(Select a.* From #temp a,(Select Max (Emp_Salary)Emp_Salary
From #Temp) b
Where a.Emp_Salary < b.Emp_Salary ) x ) y
where a.Emp_Salary < y.Emp_Salary)Z
where a.Emp_Salary = z.Emp_Salary
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sarat
TO FIND THE Nth HIGHEST SAL IN EMP TABLE
SELECT MIN (salary) as NthSalary FROM emptable WHERE
salary IN ( SELECT DISCINCT TOP N salary FROM emptable
ORDER BY salary DESC )
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / g
TO FIND THE 3rd,
select max(sal) from emptable where salary not in(select
distinct top 2 sal from emptable)
TO FIND THE 4th,
select max(sal) from emptable where salary not in(select
distinct top 3 sal from emptable)
TO FIND THE 5th,
select max(sal) from emptable where salary not in(select
distinct top 4 sal from emptable)
keep change top value...
Is This Answer Correct ? | 1 Yes | 2 No |
What do you understand by physical_only option in dbcc checkdb?
Characterize join and name diverse sorts of joins?
hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table
Do you know what is difference between stored procedure and user defined function?
Which stored procedure will you be running to add a linked server?
Define outer join in sql server joins?
What are the steps you will take, if you are tasked with securing an SQL Server?
How can we write or define DDL statements in Sql server and DML statements?
How do I setup a sql server database?
Explain rdbms?
What are functions
After removing a table from database, what other related objects have to be dropped explicitly?