Interested to Buy Any Domain ? << Click Here >> for more details...
Q1. We have a crosstab report which is having product,
region and Revenue information. Now the requirement is that
we need to add a new column with the information 'High' and
'Low' just beside the Revenue column. If Revenue is high is
should display as 'High' and if Revenue is low then it
should display as 'Low'.
Q2. If my Cube size is 2GB, now I have got the requirement
to reduce it. What are the parameters I have to follow to
reduce the cube size?
Q3. How to get the 2nd highest salary of an employee without
using any function (I mean without rownum etc.)?
Q4. What is the difference between joins and scope relationship?
- 5 Answers
- 9273 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat b
Q3.Answer: select max(sal) from emp where sal<(select max
(sal) from emp
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / s ali
Q3) In SQL server
select top 1 sal from
(select top 2 sal from emp order by sal desc ) emp2
order by sal desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / abd hfz
Q1) You can drag & drop a blank column where u set status as
High/ low using boolean var.
Q3) select sal from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
what is logs in cognos
1 Answers Target, Thomson Reuters,
What is the function of model design accelerator?
what is the difference between group span and level span
What is a query set?
how u create security to reports ????
Define datastores in cognos?
write a query to display to 10 max record from the employee table?
Hi,Can anyone tell me training centre for cognos in Mumbai?
What are all the types of indexes in Cognos?
Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer
what is a query subjects item?
how to Explain a complex report at the time of interview ? please post the answer very urgent?
Teradata 
