Changes between Version 54 and Version 55 of Noeud - parcours RHT

Timestamp:

Jan 9, 2012 4:37:53 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -223 +223 @@
 update rht.rhtvs2_roev2 set nbdams=1;
 
----Clause group by par id_bdcarthage
-select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 group by id_drain;
-
-drop table if exists rht.rht_bdcarthage_roev2_nbdams;
-create table rht.rht_bdcarthage_roev2_nbdams as
-select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 as r group by id_drain;
+---Clause group by par id_drain
+select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 group by id_drain;
+
+drop table if exists rht.rhvs2_roev2_nbdams;
+create table rht.rhtvs2_roev2_nbdams as
+select id_drain, count(nbdams) as nbdams from rht.rhtvs2_roev2 as r group by id_drain;
 }}}