SHARE
TWEET

Carte histo

a guest Oct 21st, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT crdizone.crdizonecodeim  AS CODE_IMAGE,
  2.   crdczonefld.CRDCZONEFLDCODEIM AS CODE_ENREGISTREMENT,
  3.   crdczonefld.CRDCZONEFLDLBL    AS CHAMPS,
  4.   crdizonefld.CRDIZONEFLDVALUE  AS VALEUR,
  5.   crdczone.CRDCZONELBL          AS FICHIER,
  6.   crdizone.crdizoneid           AS CRDIZONEID,
  7.   ROW_NUMBER() OVER (PARTITION BY CRD.CRDSERIAL, CRDIZONE.CRDIZONECODEIM, CRDCZONEFLD.CRDCZONEFLDCODEIM ORDER BY CRDIZONEFLD.CRDIZONEID DESC) AS RN
  8. FROM crd,
  9.   crdizone,
  10.   crdczone,
  11.   crdizonefld,
  12.   crdczonefld
  13. WHERE crd.crdserial          = 123456
  14. AND crd.crdid                =crdizone.crdid
  15. AND crdizone.crdizoneid      =crdizonefld.CRDIZONEID
  16. AND crdizone.crdczoneid      =crdczone.crdczoneid
  17. AND crdizonefld.CRDCZONEFLDID=crdczonefld.CRDCZONEFLDID
  18. ORDER BY CODE_IMAGE,
  19.   CODE_ENREGISTREMENT;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top