add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE dossier
AS
SELECT 1 origine_client_id, 2 annee_imputation UNION ALL
SELECT NULL origine_client_id, 1 annee_imputation UNION ALL
SELECT NULL, NULL UNION ALL
SELECT 1 origine_client_id, NULL annee_imputation;

Records: 4  Duplicates: 0  Warnings: 0
SELECT COUNT(DISTINCT origine_client_id, annee_imputation) FROM dossier d1;
COUNT(DISTINCT origine_client_id, annee_imputation)
1
SELECT COUNT(DISTINCT d2.origine_client_id, d2.annee_imputation) FROM (SELECT origine_client_id, annee_imputation FROM dossier) as d2;
COUNT(DISTINCT d2.origine_client_id, d2.annee_imputation)
1
SELECT COUNT(*) FROM (SELECT DISTINCT origine_client_id, annee_imputation FROM dossier) as d3;
COUNT(*)
4