CareerCup

the following is the perfect query ....

select
(select Sum(sal) from emp group by sal having sal=(select Max(sal)from emp)) -
(select Sum(sal) from emp group by sal having sal=(select Min(sal)from emp))
from dual;

select sum(sal) keep (dense_rank first order by sal asc) over (partition by dept) total_min_sal, sum(sal) keep (dense_rank last order by sal asc ) over (partition by dept)  total_max_sal,emp.* from emp

select max(s) - min(s) from ((select count(*)*value as s from salary group by (value) ) as t1)

select m1 - m2 from (select sum(salary) as m1 from Surbhi where salary = (select max(salary)from Surbhi)) as t1,(select sum(salary)as m2 from Surbhi where salary = (select min(salary)from Surbhi)) as t2;

select sum(salary)-(select sum(salary) from test where salary in (select min(salary) from test)) from test where salary in (select max(salary) from test);


The code works.. just tested it

select sum(salary)-(select sum(salary) from test where salary in (select min(salary) from test)) from test where salary in (select max(salary) from test);


The code works.. just tested it.

Thanks gullu!!!

select e.salary, count(*), sum(e.salary)
from employee e
inner join
(select max(salary) max, min(salary) min from employee) t
where e.salary in (t.max, t.min)
group by e.salary

select (select sum(salary) from employee where salary = (select max(salary) from employee)
- select sum(salary) from employee where salary = (select min(salary) from employee)) from dual;

select sum(a.salary) - sum(b.salary) from emp a, emp b
where a.salary = (select max(salary) from emp)
and b.salary = (select min(salary) from emp);

select max(salary*count )-min(salary*count ) from( select salary, count(*) as count from employee group by salary)