Answer / amol

select MAX (sallary) from emp where sallary<=(select MAX(sallary) from emp)

Answer / chandan

select slary from emp order by slary desc limit 1,1;

Answer / tarun

SELECT salary FROM tb_salary ORDER BY salary DESC LIMIT 2,1

Answer / parvezkhan pathan

select max(salary) from emp where salary not in(select
max(salary) from emp);

Answer / sai

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Answer / praveen

SELECT MAX(Salary) as 'Salary' from EmployeeDetails
where Salary NOT IN
(
SELECT TOP 1 (SALARY) from EmployeeDetails ORDER BY Salary Desc
)

Answer / pankaj kumar

SELECT filedname
FROM tablename
ORDER BY fieldname DESC
LIMIT 2 , 1

Answer / latha l

Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;


ENTER THE LEVEL MANUALLY

EX:Enter value for level: 2

YOU GET SECOND MAXIMUM SALARY.

Answer / nitin

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

Answer / chiru

select distinct sal from emp e where 2=(select
count(distinct sal) from emp where e1.sal>e.sal) order by
sal desc;

What is pl sql and why it is used for?

0 Answers  

What is the use of non clustered index?

0 Answers  

What is raid? How does it help storage of databases?

0 Answers  

Explain sql data types?

0 Answers  

Why do we use function in pl sql?

0 Answers  

Which nosql database is best?

0 Answers  

Can %notfound return null after a fetch?

0 Answers  

What is the mutating table and constraining table?

0 Answers  

Are stored procedures faster than dynamic sql?

0 Answers  

What is dml statement?

0 Answers  

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

What is composite primary key in sql?

0 Answers