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

3 votes368 views3 answers
Restart mysql mac
SQL
2 votes387 views1 answer
Oracle Column Names of a table
SQL
0 vote352 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote317 views1 answer
How to install Firebird
SQL
0 vote343 views1 answer
Increase speed of like queries postgres
SQL
1 vote360 views1 answer
Postgresql define pk sequence next number
SQL
0 vote332 views1 answer
H2 auto increment and unique
SQL
1 vote373 views1 answer
Mysql last year
SQL
2 votes359 views1 answer
Oracle run_duration average
SQL
11 votes332 views2 answers
Docker create postgres db
SQL