Answer / shrikant

You can find nth max salary

change "limit 0,n" where n = 1,2,3...

select b.sal from (select a.sal from (select distinct sal
from emp order by sal desc) a limit 0,n) b order by sal asc
limit 0,1;

Answer / shivdas suryawanshi

select salary from emp where salary=(select max(salary)
from emp where salary < (selct max(salary) from emp));

Answer / nirjesh pandey

select salary from employee order by salary DESC LIMIT(1,1)

Answer / nirjesh pandey

select salary from employee order by salary DESC LIMIT(1,1);

Answer / masthan

select *from emp where sal<selct *from emp where<select *from emp

Answer / hridayeshwar rao

select max(age) from yd where age<(select max(age) from HK) ; /// True two table Highest

SELECT * FROM HK E1 WHERE 1 =(SELECT COUNT(DISTINCT age) FROM HK E2 WHERE E1.age < E2.age); ///Second Hightest age RT single table

select age from hk e1 where (3-1) = (select count(distinct (e2.age)) from yd e2 where e2.age>e1.age);//// same True Second Hight age RT two table

select max(age) from YD where age not in (select max(age) from YD); //second hight age in single table

Suppose that salery=age

Thanks !!!

Answer / abhijeet banarse

Select level,Max(sal) from emp1
Where level=&level connect by prior sal>sal
group by level;
Enter the level No=2 (Here enter 2 manually)

Answer / moharaj m

select max(salary) from emp where salary < (select max
(salary) from emp)

Answer / rajesh chauhan

sql>select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))

Answer / waqas

Hi for second highest record follow this link
http://www.codingresolved.com/discussion/50/how-to-get-second-highest-record-in-sql#Item_2

What are pl sql procedures?

0 Answers  

What mean sql?

0 Answers  

Which sql most popular?

0 Answers  

What is the max nvarchar size?

0 Answers  

What is offset in sql query?

0 Answers  

What is the difference between sql and t sql?

0 Answers  

Is sql pronounced sequel or sql?

0 Answers  

What are the various levels of constraints?

0 Answers  

What is difference between stored function and application function?

0 Answers  

What is a sql profiler?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

What is sql comments?

0 Answers