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