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

Why sql query is slow?

0 Answers  

what is a foreign key ? : Sql dba

0 Answers  

What does where 1/2 mean in sql?

0 Answers  

What is sql indexing?

0 Answers  

Where is all the data on the internet stored?

0 Answers  

Is inner join same as self join?

0 Answers  

What is a loop in sql?

0 Answers  

What are the differences between in and exists clause?

0 Answers  

What is crud stand for?

0 Answers  

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

0 Answers  

What is auto increment feature in sql?

0 Answers  

What is the max nvarchar size?

0 Answers