/SQL/Get count of duplicate records

Get count of duplicate records

Sql query to find duplicates in column

SELECT name, COUNT(email) 
FROM users
GROUP BY email
HAVING COUNT(email) > 1

11

Source: stackoverflow.com

T-sql get duplicate rows

SELECT [CaseNumber], COUNT(*) AS Occurrences
FROM [CaseCountry]
GROUP BY [CaseNumber]
HAVING (COUNT(*) > 1)

4

Get count of duplicate records

SELECT 
    col, 
    COUNT(col)
FROM
    table_name
GROUP BY col
HAVING COUNT(col) > 1;

1

Similar codes

4 votes189 views1 answer
Data types in sql
SQL
0 vote194 views1 answer
Shell script to log mysql cpu usage
SQL
3 votes191 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote183 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
9 votes198 views5 answers
Sql limit
SQL
5 votes212 views3 answers
Show indexes mysql
SQL
0 vote183 views1 answer
Grant privileges of databse to user
SQL
0 vote208 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote225 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
14 votes223 views3 answers
SQL trim
SQL

Share