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;

Can we use delete in merge statement?

0 Answers  

What are the different parts of a package?

0 Answers  

What are pl sql data types?

0 Answers  

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

Which query operators in sql is used for pattern matching?

0 Answers  

What is pragma exception and how, when, where us

5 Answers  

What is oracle sql developer?

0 Answers  

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

How many columns should be in an index?

0 Answers  

Can you have a foreign key without a primary key?

0 Answers  

Difference between views and materialized views?

5 Answers   BirlaSoft,