Changes between Version 33 and Version 34 of Cookbook CCM21_UGA


Ignore:
Timestamp:
Aug 30, 2010 5:37:37 PM (15 years ago)
Author:
celine
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Cookbook CCM21_UGA

    v33 v34  
    106106Suppression des lignes de doublons 
    107107{{{ 
    108 delete from uga2010.wso where wso_id not in (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1) order by wso_id; 
     108delete from uga2010.wso where wso_id not in (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1); 
    109109-- Réinsertion des wso_id supprimés (sans doublon) 
    110110INSERT INTO uga2010.wso (wso_id) (select wso_id from uga2010.wso group by wso_id having count(wso_id)>1);