Predmet:Re: SQL upiti
rezultat upita, crveno bi trebalo biti za 1.6. i Vasko
id_employees | id_department | date | Id_cityDeparmentOffice | id_department | id_office | startTime | |
1001 | 10 | 2020-06-01 | 106 | 10 | 1 | 05:00:00 | |
1001 | 10 | 2020-06-01 | 606 | 10 | 1 | 05:00:00 | |
1001 | 10 | 2020-06-01 | 706 | 10 | 1 | 06:00:00 | |
1001 | 630 | 2020-06-02 | 106 | 630 | 3 | 18:00:00 | |
1001 | 330 | 2020-06-03 | 106 | 330 | 3 | 12:00:00 | |
1001 | 30 | 2020-06-04 | 106 | 30 | 3 | 06:00:00 | |
1001 | 620 | 2020-06-05 | 106 | 620 | 2 | 17:30:00 | |
1001 | 320 | 2020-06-06 | 106 | 320 | 2 | 11:30:00 | |
1001 | 320 | 2020-06-06 | 606 | 320 | 2 | 15:00:00 | |
1002 | 310 | 2020-06-01 | 106 | 310 | 1 | 11:00:00 | |
1002 | 310 | 2020-06-01 | 606 | 310 | 1 | 11:00:00 | |
1002 | 310 | 2020-06-01 | 706 | 310 | 1 | 12:00:00 | |
1002 | 10 | 2020-06-02 | 106 | 10 | 1 | 05:00:00 | |
1002 | 10 | 2020-06-02 | 606 | 10 | 1 | 05:00:00 | |
1002 | 10 | 2020-06-02 | 706 | 10 | 1 | 06:00:00 | |
1002 | 630 | 2020-06-03 | 106 | 630 | 3 | 18:00:00 | |
1002 | 330 | 2020-06-04 | 106 | 330 | 3 | 12:00:00 | |
1002 | 30 | 2020-06-05 | 106 | 30 | 3 | 06:00:00 | |
1003 | 610 | 2020-06-01 | 106 | 610 | 1 | 17:00:00 | |
1003 | 610 | 2020-06-01 | 606 | 610 | 1 | 17:00:00 | |
1003 | 610 | 2020-06-01 | 706 | 610 | 1 | 18:00:00 | |
1003 | 310 | 2020-06-02 | 106 | 310 | 1 | 11:00:00 | |
1003 | 310 | 2020-06-02 | 606 | 310 | 1 | 11:00:00 | |
1003 | 310 | 2020-06-02 | 706 | 310 | 1 | 12:00:00 | |
1003 | 10 | 2020-06-03 | 106 | 10 | 1 | 05:00:00 | |
zivot je moja domovina.
Ovaj post je ureden
1
puta. Posljednja izmjena 08.06.2020 08:51 od strane Avko.