/SQL/Finding duplicate column values in table with sql

Finding duplicate column values in table with sql

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

Source: chartio.com

Sql query to find duplicates in column

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

Source: stackoverflow.com

FIND DUPLICATES IN COLUMN SQL

declare @YourTable table (id int, name varchar(10), email varchar(50))

INSERT @YourTable VALUES (1,'John','John-email')
INSERT @YourTable VALUES (2,'John','John-email')
INSERT @YourTable VALUES (3,'fred','John-email')
INSERT @YourTable VALUES (4,'fred','fred-email')
INSERT @YourTable VALUES (5,'sam','sam-email')
INSERT @YourTable VALUES (6,'sam','sam-email')

SELECT
    name,email, COUNT(*) AS CountOf
    FROM @YourTable
    GROUP BY name,email
    HAVING COUNT(*)>1

-1

Source: stackoverflow.com

Similar codes

0 vote235 views1 answer
Setval in postgres
SQL
5 votes231 views2 answers
Sql server check port number
SQL
0 vote266 views1 answer
Sql query for login with email or username
SQL
1 vote196 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
0 vote224 views1 answer
Update view sql
SQL
3 votes215 views1 answer
Oracle user quota unlimited
SQL
-1 vote220 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
4 votes225 views1 answer
Force drop all tables postgres
SQL
0 vote225 views1 answer
Drop unique
SQL
0 vote236 views2 answers
Nodejs mysql convert to plain object
SQL