SELECT columnname FROM tablename GROUP BY columnname HAVING COUNT(*) > 1
> >I am trying to remember the syntax for finding duplicate > >records in a table based on a specific column. > > > >Does someone recall the select command to do such a task?
SELECT columnname FROM tablename GROUP BY columnname HAVING COUNT(*) > 1
> >I am trying to remember the syntax for finding duplicate > >records in a table based on a specific column. > > > >Does someone recall the select command to do such a task?