Answers for "sql instr for sqlite"

SQL
2

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
Posted by: Guest on May-26-2020
1

mysql in

SELECT 
    column1,column2,...
FROM
    table_name
WHERE 
    column1 IN ('value1','value2',...);
Posted by: Guest on February-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language