faraz akram

faraz akram

  • NA
  • 129
  • 0

query builder in table adapter

Feb 25 2009 1:56 AM

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


Answers (1)