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
- 6134 Views
- IBM, I also Faced
- E-Mail Answers
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
What does cheating measurement mean?
Reusable transformation and shortcut differences
Enlist the various types of transformations.
How many types of sessions are there in informatica.please explain them?
what is unit testing?tell me proceedure
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is enterprise data warehousing?
How many ways are there to do 'remove duplicate records in informatica'?
What is intricate mapping?
Sequence generator, when you move from develoment to production how will you reset
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differences between connected and unconnected lookup?
How to elaborate tracing level?
What is exclusive and normal mode for repository services?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
