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
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is cognos connection?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
What is the difference between the content store and content manager?
Cleared COG-112 with 100% score today. What next certification should i go for?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?
---------------Tell me about DWH Concepts?
What are the types of security?
how to merge 2 crosstabs thans
what are slowly changing dimensions? Why we are used scd?
What is called cognos reporting tool?
How to create a cube in Transformer? What is the process? Please mention process thank u
