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;

Can we commit inside a trigger?

0 Answers  

What is a left inner join?

0 Answers  

What is a unique key and primary key and foreign key?

0 Answers  

select 1,col1,col2 from table1. output?

5 Answers   Ramco,

What are sql injection vulnerabilities?

0 Answers  

what is check constraint? : Sql dba

1 Answers  

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

What are the 3 types of behavioral triggers?

0 Answers  

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

What is a constraint. Types of constraints ?

5 Answers   Accenture, BirlaSoft,

What is the maximum size of sqlite database?

0 Answers  

What is magic table?

6 Answers