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
5. Which type of report you build more, list, crosstab or chart and why?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
what is the difference between filter and condition?
How security is concerned with Reportnet? Explain its implementing steps.
What are all the components of Report Studio?
Can you define cube?
What is difference between content store and content manager?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are products of cognos?
what are the names of the reports that you prepared?
Is it possible to join multiple Databases in a Catalog?
What are the themes in a data warehouse?
Can you define a catalog and types of catalogs in cognos?
what is hints in cognos and where we use it.
