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 do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
what is the difference between native sql and cognos sql?
How to join multiple db in catalog?
--------------Diff b/w ODS and OLAP?
hi friends pls forward impropmtu interview question
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What is the function of model design accelerator?
What is metric store database?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How to create a cube in Transformer? What is the process? Please mention process thank u
can we insert all types of charts in a list report? what r the realtime prompts?
Can you define metrics designer?
What is the difference between low affinity and high affinity connections?
Can you define cube?
What is the use of report studio?
