How to view dupicate data in mysql

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • RAJASEKHAR SRIN
    New Member
    • Jan 2011
    • 1
    #1

    How to view dupicate data in mysql

    Give the answer breifly
    Tags: None
    • code green
      Recognized Expert Top Contributor
      • Mar 2007
      • 1726
      #2
      use
      Code:
      GROUP BY `field1` 
HAVING (
COUNT( `field2` ) >1)

        Comment

        • AutumnsDecay
          New Member
          • Mar 2008
          • 170
          #3
          edit.

          I misread everything on this page.. morning coffee time.

            Comment

            Previous template Next
            Working...