×

Welcome to TagMyCode

Please login or create account to add a snippet.
 

Searching for duplicate values in a column

0
0
 
0
Language: SQL
Posted by: Marcus Hamilton
Added: Sep 28, 2017 12:47 PM
Views: 2539
Tags: sql
  1. SELECT column_name, COUNT(column_name)
  2. FROM TABLE
  3. GROUP BY column_name
  4. HAVING COUNT (column_name) > 1;
  5.  
  6.  

Write a comment

To post comments, please log in or register.