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

0 vote330 views4 answers
Forenkey code alchemy sql
SQL
0 vote321 views1 answer
Get foreign table names mysql
SQL
1 vote337 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote334 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote289 views1 answer
Metada in sql
SQL
0 vote316 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote330 views1 answer
Get create sql of hibernqte entity
SQL
13 votes349 views5 answers
Alter table query sql server change column
SQL
14 votes335 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
4 votes314 views1 answer
Oracle show errors compilation
SQL