var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sql qyery
I have a table with employees and a view with some informations for them.
I want to find the employees that have
the same as
select (emp.dosivalue+emp.dosi2value +emp.dosi3value+)*2
The emp_id is the primary key of emp (employees).
select sum(nvl(empv.posovalue,0)) from empv group by emp_id,per_id
How I may do that?
I want that at oracle reports.
Just an idea; see if you can do something with it:
from (select ename, (val + val2 + val3) val_t
(select ename, sum(val) val_v
group by ename
where x.ename = y.ename
and x.val_t = val_V;
I change this query and I thing it works.