Answer / r.arjunarao

select a.sal from emp a where 2=(select count(distinct(b.sal)) from emp b where b.sal>=a.sal)

Answer / rakesh a.

select Amount from PurchaseOrderDetail pod where
1=(select COUNT(amount) from PurchaseOrderDetail pod2 where pod2.Amount>pod.Amount)

Answer / jayshree

select max(sal) from table_name where sal not in (select
max(sal) from table_name)

Answer / tanmoy

SELECT MIN(sal) FROM (SELECT sal FROM emp ORDER BY sal DESC LIMIT 2) AS a ;

Answer / surya

Select max(sal) from employee where sal not in(select max
(sal) from employee)

Answer / hemanth kumar

select salary from employees where rowid=(select rowid from
employees where rownum<=2
minus
select rowid from employees where rownum<2)
order by salary

Answer / manoj

select * from emp
where
sal=(select MAX(sal) from emp
where
sal<(select MAX(sal)from emp))

Answer / vinod dubey

select * from emp
where sal = (select max(sal) from emp where sal <>(select max(sal) from emp));

it will defiantly work

best of luck

Answer / nevin

select min(salary) from (select top 2 sal from table_name order by sal desc)salary

Answer / ram achare

for 2nd highest salary
select sal from(select distinct sal from emp order by sal desc limit 2)emp order by salary limit 1;
for 3rd highest salary
select sal from(select distinct sal from emp order by sal desc limit 3)emp order by salary limit 1;

Are sql database names case sensitive?

0 Answers  

What is an exception in pl/sql?

0 Answers  

What is record data type?

0 Answers  

Can a composite key be null?

0 Answers  

Is and as keyword in pl sql?

0 Answers  

Can primary key be changed?

0 Answers  

Show the two pl/sql cursor exceptions.

0 Answers  

What are the different ways to optimize a sql query?

0 Answers  

How can we avoid duplicating records in a query?

0 Answers  

What is cursor and its types?

0 Answers  

What is user define exception and example

1 Answers   HP, KP,

What is write ahead logging in sql server?

0 Answers