Sunday, April 21, 2019

SQL Query to find duplicate values in a table

SQL Query to find duplicate values in a table


SELECT
col,
COUNT(col)
FROM.
table_name.
GROUP BY col.
HAVING COUNT(col) > 1;
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQL Query to find Customer, Customer Account and Customer Sites Information

/****************************************************************************** *PURPOSE: Query to Customer, Customer Account and Customer...