Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6126 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sambu
select id,count(*) from <table name>
group by id having count(*)>1;
The above gives us desired output
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
update strategy transformation in informatica
What are the components of the workflow manager?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain joiner transformation in informatica
How to load a Dimension ? and how to load a fact table?
Explain the different lookup methods used in informatica?
What is target designer and target load order?
Explain what is informatica metadata and where is it stored?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Describe data concatenation?
What is the cumulative sum and moving sum?
What are the different types of repositories created using informatica?
How to convert multiple rows to single row (multiple columns) in informatica
Mention some types of transformation?
What does reusable transformation mean?
