Changes between Version 29 and Version 30 of Напредни извештаи од базата


Ignore:
Timestamp:
02/13/22 23:03:57 (3 years ago)
Author:
186102
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Напредни извештаи од базата

    v29 v30  
    136136        from project.delivery as d
    137137        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) <=3
    138         --group by d.date,d.delivery_id
    139138)as prv,
    140139(
     
    142141        from project.delivery as d
    143142        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 3 and extract(month from d.date) <=6
    144         --group by d.date,d.client_id
    145143)as vtor,
    146144(
     
    148146        from project.delivery as d
    149147        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 6 and extract(month from d.date) <=9
    150         --group by d.date,d.client_id
    151148)as tret,
    152149(
     
    154151        from project.delivery as d
    155152        where extract(year from d.date) = extract(year from now()) and extract(month from d.date) > 9 and extract(month from d.date) <=12
    156         --group by d.date,d.client_id
    157153)as cetvrt
    158154}}}