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;

What is a ddl command?

0 Answers  

Which one is better sql or oracle?

0 Answers  

What is scalar and vector?

0 Answers  

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

how to create a database in oracle?

3 Answers  

can we update a view which is created from two tables

11 Answers  

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

Can we use pl sql in mysql?

0 Answers  

How can we make an if statement within a select statement?

0 Answers  

Does mysql_real_escape_string prevent sql injection?

0 Answers  

What is a procedure in pl sql?

0 Answers  

What are sql built in functions?

0 Answers