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 |
Distinguish between commit and rollback?
Define compound operators?
How to convert a unicode strings to non-unicode strings?
How to create user defined functions with parameters?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
What are the various Isolation levels?
how can you move the master database
What are different backups available in sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the command to change the recovery model?
Why we use functions in sql server?
When I run the sql server 2000 setup, it just hangs. What do I do?