Changes between Version 29 and Version 30 of Напредни извештаи од базата
- Timestamp:
- 02/13/22 23:03:57 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Напредни извештаи од базата
v29 v30 136 136 from project.delivery as d 137 137 where extract(year from d.date) = extract(year from now()) and extract(month from d.date) <=3 138 --group by d.date,d.delivery_id139 138 )as prv, 140 139 ( … … 142 141 from project.delivery as d 143 142 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_id145 143 )as vtor, 146 144 ( … … 148 146 from project.delivery as d 149 147 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_id151 148 )as tret, 152 149 ( … … 154 151 from project.delivery as d 155 152 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_id157 153 )as cetvrt 158 154 }}}