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
Answer Posted / ruchi
SELECT ID,COUNT(*) FROM TABLE1
GROUP BY ID
HAVING COUNT(*)>1
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Why update strategy and union transformations are active?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What are the tasks that source qualifier perform?
How to create a non-reusable instance of reusable transformations?
What is workflow monitor?
What are the differences between oltp and olap?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the function of look up transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are junk dimensions?
What are the various types of transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Write the advantages of partitioning a session?
What is standalone command task?
What is option by which we can run all the sessions in a batch simultaneously?