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;

Answer / riyazkhan

select Sal from Employee where Sal != (select max(Sal) from Employee) Order By Sal desc

Answer / ranjith

Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)

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)

Answer / ravi kumar

SELECT MIN(sal) FROM Emp WHERE sal in
(SELECT TOP 2 DISTINCT sal from Emp ORDER BY DESC)

Answer / harsha

select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc

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

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

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 )

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...

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

What is importing utility?

0 Answers  

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

Distinguish between nested subquery and correlated subquery?

0 Answers  

Write a SQL query to delete a table?

0 Answers   Amdocs,

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

What is the difference between Normalization and De-normalization?

0 Answers   TCS,

What is de-normalization in sql database administration? Give examples?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

What are the differences between char and varchar in ms sql server?

0 Answers