EvaldoMaciel

MAQL - Data

Nov 25th, 2021 (edited)
3,826
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT MAX(SELECT MAX(SELECT (1000000 * MAX(DAY OF MONTH (DATA))) + (10000 * MAX(MONTH (DATA))) + (MAX(YEAR (DATA)) -2020+2020)) BY DATA Chave) BY YEAR (DATA) ALL OTHER
  2.  
  3. /*
  4.     A mascara deve ser
  5.     0#/0#/####
  6.  
  7.     Em Year (Data)) -2020+2020) o primeiro 2020 deve ser um valor de atributo, o segundo é valor digital.
  8.  
  9. SELECT MAX(SELECT MAX(SELECT
  10. (1000000 * MAX([/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1094])) +
  11. (10000 * MAX([/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1088])) +
  12. (MAX([/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1080])
  13. -[/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1080/elements?id=2020]+2020)) BY [/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1016638])
  14.  BY [/gdc/md/ogbz4i09i4ugi8m23m1ig3u9orjg5njw/obj/1080] ALL OTHER
  15. */
RAW Paste Data