I am having a table with columns
ID NAME
1 x and the requirement is to get the o/p like this
1 y ID Count(*)
1 z 1 3
2 a 2 2
2 b
3 c
so write a sql query to get the id n how many times its
count of repetition n there u shouldn't get the distinct(i.e
id-3)
Reply as early as possible
- 3 Answers
- 5048 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / akash khanwalkar
This one is without using HAVING clause:
SELECT TEMP.ID, TEMP.ID_COUNT FROM
(
SELECT ID AS ID, COUNT(ID) AS ID_COUNT FROM TEMP_ID_TABLE
GROUP BY ID
) TEMP
WHERE TEMP.ID_COUNT > 1;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
What is workflow monitor?
explan ur project architecture?
How would you join a node to the already existing domain?
How to update a particular record in target with out running whole workflow?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
in reporting we add some new objects,how we get the count of the newly added objects to the report
where to store informatica rejected data?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Explain the pipeline partition with real time example?
What are the differences between joiner transformation and source qualifier transformation?
Briefly define reusable transformation?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Why update strategy and union transformations are active?
What is Session and Batches?
