Changes between Version 2 and Version 3 of Franchissabilite piscicole

Timestamp:

May 6, 2010 10:44:19 AM (15 years ago)

Author:

celine

Comment:

--

Franchissabilite piscicole

@@ -22 +22 @@
     where fra_note is not null
     group by fra_ref_id,fra_esp_id) as sub
-    where nombre>1; -- 63 doublons
+    where nombre>1; -- 62 doublons (dont un avec 4 données identiques)
 }}}
 
@@ -36 +36 @@
 -- 4/ nombre de valeurs totales
 {{{
-select count (*) from geobs2010.franchissabilite_piscicole -- 24964
+select count (*) from geobs2010.franchissabilite_piscicole -- 26510 (ancienne version : 24964)
 }}}
 
@@ -47 +47 @@
     from geobs2010.franchissabilite_piscicole) as distinctes)
 
-ORDER BY fra_ref_id; -- 107 lignes
+ORDER BY fra_ref_id; -- 493 lignes (ancienne version : 107 lignes)
 }}}
 
@@ -82 +82 @@
     (SELECT fra_ref_id, fra_esp_id,fra_note FROM duplicated
     group by fra_ref_id, fra_esp_id,fra_note
-    HAVING COUNT(*) > 1) )--115
+    HAVING COUNT(*) > 1) )-- 86 (ancienne version :115)
 }}}