1 2 3 4 5 6 7 8 9 10 11
| SELECT TO_CHAR(DAT, 'ddmmyyyy') AS LADATE, POSX, POSY,TX_ORR2
FROM GRILLE_ETP_Q
WHERE DAT BETWEEN to_timestamp('20012005', 'ddmmyyyy') AND to_timestamp('20022005', 'ddmmyyyy')
OR DAT BETWEEN to_timestamp('20012006', 'ddmmyyyy') AND to_timestamp('20022006', 'ddmmyyyy')
OR DAT BETWEEN to_timestamp('20012007', 'ddmmyyyy') AND to_timestamp('2002007', 'ddmmyyyy')
OR DAT BETWEEN to_timestamp('20012008', 'ddmmyyyy') AND to_timestamp('20022008', 'ddmmyyyy')
OR DAT BETWEEN to_timestamp('20012009', 'ddmmyyyy') AND to_timestamp('20022009', 'ddmmyyyy')
OR DAT BETWEEN to_timestamp('20012010', 'ddmmyyyy') AND to_timestamp('20022010', 'ddmmyyyy')
GROUP BY LADATE, POSX, POSY, TX_ORR2
ORDER BY LADATE ASC, POSX ASC, POSY ASC |
Partager