hi
i have a table having duplicate rows i am using a query in .net query builder
"select count(*),columnA,columnB from table
where (columnC=?)
group by columnA,columnB
having count(*)>1"
this query is working fine and pulling up the number of rows having duplication on basic of colA,ColB. But it is showing a single row having count (*)>1
i want it to be pulled out all rows having duplication.i.e right away it is pulling upone row having duplicates i want all rows attached with that duplicate
hope u understand
Vijaya KadiyalaPosted Feb 27, 2009, 4:12 PM
Hi
Can you tell me what do you mean by " i want all rows attached with that duplicate". Do you want to pul the data from other tables based on this duplication.
Thanks -- Vijaya Kadiyala