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;

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

What are the benefits of pl sql?

0 Answers  

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

What is sharding in sql?

0 Answers  

What is the difference between drop and truncate commands?

0 Answers  

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

What are the basic sql commands?

0 Answers  

what is check constraint? : Sql dba

1 Answers  

when a procedure /package is getting invalidated?

4 Answers   TCS,

How can I delete duplicate rows?

0 Answers