Changes between Version 12 and Version 13 of AdvancedReports
- Timestamp:
- 01/24/22 15:13:51 (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
AdvancedReports
v12 v13 13 13 group by 1 14 14 order by pozajmeni_knigi_od_kategorija desc 15 fetch first row only;16 15 }}} 17 16 … … 28 27 group by 1,2 29 28 order by pozajmuvanja desc 30 fetch first row only;31 29 }}} 32 30 … … 54 52 group by 1 55 53 order by prosecna_ocena desc 56 fetch first row only;57 54 }}} 58 55 59 56 == Прикажување на најчитаната книга на еден автор за одреден временски период 60 57 {{{#!sql 61 select * from pozajmica;62 58 select k.naslov, a.ime, count(p.id_na_pozajmica) as pozajmuvanja from 63 59 pozajmica as p … … 70 66 group by 1,2 71 67 order by pozajmuvanja desc 72 fetch first row only;73 68 }}} 74 69
