Interested to Buy Any Domain ? << Click Here >> for more details...
2. What is With Clause In Cognos?
- 2 Answers
- 14112 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated
| Is This Answer Correct ? | 1 Yes | 2 No |
When we deploy the report to live the client get the data error how can we resolve that
What are the types of folder present in cognos?
Column level security in report
what is stitch query in reportnet?
can any one explain about blue prints&performance tuning in cognos?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
How Metrics Studio is better than Report Studio?
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
how to create measures and dimensions?
What is the difference between set functions and filter function in dimensional data?
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
Teradata 
