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 is snowflake sql?

0 Answers  

How to fetch records from a partitioned table?

2 Answers   HSBC,

How do you go back in sql?

0 Answers  

what is schema? : Sql dba

0 Answers  

What are the packages in pl sql?

0 Answers  

What is procedure and function in sql?

0 Answers  

What are pl/sql cursors?

0 Answers  

What are the query optimization techniques?

0 Answers  

what is 'mysqld'? : Sql dba

0 Answers  

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

What are the benefits of pl sql?

0 Answers  

What is the cause of mutating table error and how can we solve it?

0 Answers