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

can you any body tell me which service pack is installed in the sql server?

3 Answers  

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

What is the purpose of object explorer and its features? : sql server management studio

0 Answers  

What are the ways available in sql server to execute sql statements?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

How can I tell if sql server is 32 or 64 bit?

0 Answers  

To find second largest salary in Employee table

17 Answers   CSS,

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE

2 Answers   IBM, TCS,

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

How to insert multiple rows with a subquery?

0 Answers