Predmet:Re: SQL upiti
rezultat bi trebao pokazati ovo:
date | id_employees | id_department | id_office | startTime |
2020-06-01 | 1001 | 10 | 1 | 05:00:00 |
2020-06-01 | 1002 | 310 | 1 | 11:00:00 |
2020-06-01 | 1003 | 610 | 1 | 17:00:00 |
2020-06-02 | 1008 | 30 | 3 | 06:00:00 |
2020-06-02 | 1009 | 330 | 3 | 12:00:00 |
2020-06-02 | 1001 | 630 | 3 | 18:00:00 |
2020-06-03 | 1009 | 30 | 3 | 06:00:00 |
2020-06-03 | 1001 | 330 | 3 | 12:00:00 |
2020-06-03 | 1002 | 630 | 3 | 18:00:00 |
2020-06-04 | 1001 | 30 | 3 | 06:00:00 |
2020-06-04 | 1002 | 330 | 3 | 12:00:00 |
2020-06-04 | 1003 | 630 | 3 | 18:00:00 |
2020-06-05 | 1008 | 20 | 2 | 05:30:00 |
2020-06-05 | 1009 | 320 | 2 | 11:30:00 |
2020-06-05 | 1001 | 620 | 2 | 17:30:00 |
2020-06-06 | 1009 | 20 | 2 | 09:00:00 |
2020-06-06 | 1001 | 320 | 2 | 15:00:00 |
2020-06-07 | 1001 | FD | null | null |
FD = freeday
zivot je moja domovina.
Ovaj post je ureden
1
puta. Posljednja izmjena 08.06.2020 08:54 od strane Avko.