If you ever needed to generate summary of some date range with 0 for missing intervals (for example orders grouped by days with 0 for days without orders) then check this link (http://www.databasesoup.com/2013/08/fancy-sql-monday-generateseries-and.html ) for quick tip for how to do this in PostgreSQL using generate_series and cross join.
9 marca 2014 14:14 Brak komentarzy Komentuj Kategorie: Bez kategorii
Brak komentarzy