php mssql

I have a select query that pulls data
but some time the record is duplicated
E.g
expr2   name          date
123      beridius      10/10/2012
123      beridius      10/10/2012
122      smith           09/10/2012


how would I count the number of duplicates?
LVL 2
beridiusAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
to start with, this would give you all the info for which you have duplicates:
select expr2, name, date, count(*)
  from yourtable
group by expr2, name, date
having count(*) > 1 

Open in new window


is that what you want?
see also this article:
http://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html
0
All Courses

From novice to tech pro — start learning today.