var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Any alternative for INLINE SQL QUERY?
I need alternative solution to INLINE SQL query.
select d.deptid, d.deptname,
( select count(empid) from emp e where e.deptid=d.deptid )
from dept d
The solution can be a nested query or any other alternative preferably without cursors.
select dept, count(*)
select dept,1 as cnt
group by req,seq,item, dept
group by dept
Why do you need it? If we don't understand what you are trying to do or avoid, odds are good that we'll give you a useless answer.