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
- 5978 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
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the use of code page?
How do you load only null records into target?
How to improve the performance of a session using sorter transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a mapplet/worklet in informatica?
What is a transaction control transformation?
How to implement security measures using repository manager?
What is the procedure for creating independent data marts from informatica 7.1?
What is data transformation manager process?
What are Dimensional table?
What are the types of data warehouses?
How you can differentiate between connected lookup and unconnected lookup?
Enlist the tasks for which source qualifier transformation is used.
What are batches?
