Doublon sql

SELECT _column, COUNT(*) 
FROM _table
GROUP BY _column
HAVING COUNT(*) > 1

Doublon sql

-- exemple
-- recherche doublon sur la table demande pour les champs : 
-- nom_demandeur, prenom_demandeur, actif

SELECT   COUNT(*) AS nbr_doublon, nom_demandeur, prenom_demandeur, actif
FROM     demandes
GROUP BY nom_demandeur,prenom_demandeur,actif
HAVING   COUNT(*) > 1

Similar codes

1 vote123 views1 answer
Convert epoch to date in sql server
SQL
3 votes144 views5 answers
Foreign keys
SQL
0 vote117 views1 answer
Low level operator in dbms
SQL
2 votes124 views1 answer
Metasploit start postgresql
SQL
5 votes113 views1 answer
How to check nls format in oracle
SQL
0 vote143 views2 answers
How to take recent row without limit in mysql
SQL
0 vote122 views1 answer
How to query all tables mysql at the same time
SQL
0 vote112 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote116 views1 answer
Postgresql remove new line from string
SQL
0 vote116 views2 answers
How to check if a column exists in a SQL Server table?
SQL