Witam
Mam taki oto kod
SELECT
COUNT (CASE WHEN DATA BETWEEN date('now','start of month')
AND date('now','start of month','+1week','-1 day') THEN ID_URLOPU ELSE 0 END) AS 'Tydzień 1',
COUNT (CASE WHEN DATA BETWEEN date('now','start of month','+ 1 week')
AND date('now','start of month','+2week','-1 day') THEN ID_URLOPU ELSE 0 END) AS 'Tydzień 2',
COUNT (CASE WHEN DATA BETWEEN date('now','start of month','+ 2 week')
AND date('now','start of month','+3week','-1 day') THEN ID_URLOPU ELSE 0 END) AS 'Tydzień 3',
COUNT (CASE WHEN DATA BETWEEN date('now','start of month','+ 3 week')
AND date('now','start of month','+4week','-1 day') THEN ID_URLOPU ELSE 0 END) AS 'Tydzień 4',
COUNT (ID_URLOPU) AS 'RAZEM'
FROM OBECNOSCI WHERE ID_PRACOWNIKA = 1;
Dlaczego nie zlicza mi obecnosci wg podanych przedziałów tylko od razu wszystko na raz i zwraca cos takiego
1 wierszy przetworzonych w 0.015 sekund(y).
------------------------------------
Wyniki:
Tydzień 1 |Tydzień 2 |Tydzień 3 |Tydzień 4 |RAZEM
----------------+----------------+----------------+----------------+----------------
7 |7 |7 |7 |7