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
- 8859 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 |
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
in u r data u having duplicates how to fetch the latest data in our report?
what are ERP systems?
using of matric studio we can developed to scorecard ... what is the meaning by scorecords
how u publish the packages in framework manager
How can we create a dynamic column name in cognos?
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
1. Explain your project.
How to select multiple values from type-in prompt?
Can you define slice?
What is Star schema group?
what is exact catalog size?
Teradata 
