Sql check double value

Sql query to find duplicates in column

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

Source: stackoverflow.com

Sql check double value

SELECT
    name, email, COUNT(*)
FROM
    users
GROUP BY
    name, email
HAVING 
    COUNT(*) > 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

8 votes120 views10 answers
Sql
SQL
31 votes113 views3 answers
Sql count(*)
SQL
0 vote107 views1 answer
Suse status MySQL
SQL
20 votes107 views5 answers
Sql show tables
SQL
0 vote118 views2 answers
How to count codition
SQL
0 vote71 views3 answers
Mysql calculate age from date of birth
SQL
0 vote110 views1 answer
Sql quary intervewi question
SQL
1 vote108 views1 answer
How to install mysql 8.0 windows service
SQL
1 vote109 views1 answer
Where not in array sql
SQL
3 votes139 views2 answers
Wp do sql query from function
SQL