Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / thanjairajan@gmail.com
The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.
For example:
WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are all types of Batches?
How do you call a store procedure within a transformation?
What are types of batch available in cognos?
What are the types of studio present in Cognos?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
what is the procedure for scheduling conditional rendering?
What is the information present in the cognos configuration file?
What is the difference between low affinity and high affinity connections?
What are the different types of important services used in cognos?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
-----------------What is Direct and Conventional loading?
What is meant by alternate drill down with ex?
What is cognos reporting tool?
----------------Diff b/w Dimensional modeling and Relational modeling?
how u will design the report if the objects are available
