Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql change user password
Sql :: mysql group_concat distinct
Sql :: uninstall mysql on ubuntu
Sql :: put line oracle
Sql :: oracle table privileges
Sql :: refresh postgres config
Sql :: rails execute sql
Sql :: mysql default timestamp value to be current timestamp
Sql :: database url postgres
Sql :: how to restart mysql in linux
Sql :: how to list columns for particular tables in postgresql
Sql :: cast string to datetime mysql
Sql :: pl sql escape &
Sql :: c# datetime to sql server datetime
Sql :: spark sql concatenate string and int
Sql :: search stored procedures by name
Sql :: find table for column name in sql
Sql :: get the list of all tables in sql server
Sql :: postgres stop server mac
Sql :: alter default column value oracle
Sql :: [2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Sql :: mysql concat two columns laravel eloquent
Sql :: ora-01950 no privileges on tablespace
Sql :: sql try catch
Sql :: Unit mysql.service could not be found.
Sql :: describe table mysql
Sql :: postgresql reset auto_increment index
Sql :: psql is not recognized
Sql :: sql current_timestamp
Sql :: oracle list datafiles in tablespace

Search

SQL

doublon sql

ADD CONTENT