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;

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

Is stored procedure faster than query?

0 Answers  

We have a CURSOR then we need BULK COLLECT?

1 Answers  

what is the syntax for using sql_variant_property? : Transact sql

0 Answers  

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

What is the difference between cross join and natural join?

0 Answers  

Is sql free?

0 Answers  

Does db2 use sql?

0 Answers  

How does one load ebcdic data? : aql loader

0 Answers  

Can we interchange parameters in procedure while calling

1 Answers   TCS,

What is meant by cursor in sql?

0 Answers