[ Markanto @ 25.02.2010. 13:17 ] @
Kako da u Ibexpertu dobijem da mi sortira podatke po mjesecima? Nešto tipa: select sum(tablica.vrijednost), tablica.datum from tablica group by month(tablica.datum) order by month(tablica.datum) |
[ Markanto @ 25.02.2010. 13:17 ] @
[ captPicard @ 25.02.2010. 14:20 ] @
Code: select sum(polje), datum from tablica group by nesto order by extract(month from datum) [ Markanto @ 25.02.2010. 14:48 ] @
Puno hvala, ovo je bilo riješenje !!
Copyright (C) 2001-2025 by www.elitesecurity.org. All rights reserved.
|