Predmet:Re: SQL upiti
date | id_employees | name | id_department | id_office | startTime | |
2020-06-01 | 1001 | Vasko | 10 | 1 | 05:00:00 | TREBA |
2020-06-02 | 1002 | Luka | 10 | 1 | 05:00:00 | |
2020-06-03 | 1003 | Marko | 10 | 1 | 05:00:00 | |
2020-06-04 | 1004 | Ivan | 10 | 1 | 05:00:00 | |
2020-06-05 | 1005 | Marta | 10 | 1 | 05:00:00 | |
2020-06-01 | 1004 | Ivan | 20 | 2 | 05:30:00 | |
2020-06-02 | 1005 | Marta | 20 | 2 | 05:30:00 | |
2020-06-03 | 1006 | Smiljan | 20 | 2 | 05:30:00 | |
2020-06-04 | 1007 | Mitar | 20 | 2 | 05:30:00 | |
2020-06-05 | 1008 | Ahmed | 20 | 2 | 05:30:00 | TREBA |
2020-06-04 | 1001 | Vasko | 30 | 3 | 06:00:00 | TREBA |
2020-06-05 | 1002 | Luka | 30 | 3 | 06:00:00 | |
2020-06-01 | 1007 | Mitar | 30 | 3 | 06:00:00 | |
2020-06-02 | 1008 | Ahmed | 30 | 3 | 06:00:00 | TREBA |
2020-06-03 | 1009 | Aleksandar | 30 | 3 | 06:00:00 | |
2020-06-01 | 1002 | Luka | 310 | 1 | 11:00:00 | TREBA |
2020-06-02 | 1003 | Marko | 310 | 1 | 11:00:00 | |
2020-06-03 | 1004 | Ivan | 310 | 1 | 11:00:00 | |
2020-06-04 | 1005 | Marta | 310 | 1 | 11:00:00 | |
2020-06-05 | 1006 | Smiljan | 310 | 1 | 11:00:00 | |
2020-06-01 | 1005 | Marta | 320 | 2 | 11:30:00 | |
2020-06-02 | 1006 | Smiljan | 320 | 2 | 11:30:00 | |
2020-06-03 | 1007 | Mitar | 320 | 2 | 11:30:00 | |
2020-06-04 | 1008 | Ahmed | 320 | 2 | 11:30:00 | |
2020-06-05 | 1009 | Aleksandar | 320 | 2 | 11:30:00 | TREBA |
2020-06-03 | 1001 | Vasko | 330 | 3 | 12:00:00 | TREBA |
2020-06-04 | 1002 | Luka | 330 | 3 | 12:00:00 | TREBA |
2020-06-05 | 1003 | Marko | 330 | 3 | 12:00:00 | |
2020-06-01 | 1008 | Ahmed | 330 | 3 | 12:00:00 | |
2020-06-02 | 1009 | Aleksandar | 330 | 3 | 12:00:00 | TREBA |
2020-06-01 | 1003 | Marko | 610 | 1 | 17:00:00 | TREBA |
2020-06-02 | 1004 | Ivan | 610 | 1 | 17:00:00 | |
2020-06-03 | 1005 | Marta | 610 | 1 | 17:00:00 | |
2020-06-04 | 1006 | Smiljan | 610 | 1 | 17:00:00 | |
2020-06-05 | 1007 | Mitar | 610 | 1 | 17:00:00 | |
2020-06-03 | 1008 | Ahmed | 610 | 1 | 17:00:00 | |
2020-06-05 | 1001 | Vasko | 620 | 2 | 17:30:00 | TREBA |
2020-06-01 | 1006 | Smiljan | 620 | 2 | 17:30:00 | |
2020-06-02 | 1007 | Mitar | 620 | 2 | 17:30:00 | |
2020-06-04 | 1009 | Aleksandar | 620 | 2 | 17:30:00 | |
2020-06-02 | 1001 | Vasko | 630 | 3 | 18:00:00 | TREBA |
2020-06-03 | 1002 | Luka | 630 | 3 | 18:00:00 | |
2020-06-04 | 1003 | Marko | 630 | 3 | 18:00:00 | TREBA |
2020-06-05 | 1004 | Ivan | 630 | 3 | 18:00:00 | |
2020-06-01 | 1009 | Aleksandar | 630 | 3 | 18:00:00 | |
2020-06-06 | 1006 | Smiljan | 10 | 1 | 05:00:00 | |
2020-06-06 | 1009 | Aleksandar | 20 | 2 | 09:00:00 | |
2020-06-06 | 1007 | Mitar | 310 | 1 | 11:00:00 | |
2020-06-06 | 1001 | Vasko | 320 | 2 | 15:00:00 | TREBA |
2020-06-06 | 1008 | Ahmed | 610 | 1 | 17:00:00 | |
2020-06-07 | 1007 | Mitar | 10 | 1 | 06:00:00 | |
2020-06-07 | 1008 | Ahmed | 310 | 1 | 12:00:00 | |
2020-06-07 | 1009 | Aleksandar | 610 | 1 | 18:00:00 | |
2020-06-07 | 1001 | Vasko | FD | NULL NULL | | TREBA |
2020-06-06 | 1002 | Luka | FD | NULL NULL | | |
2020-06-07 | 1002 | Luka | FD | NULL NULL | | |
2020-06-06 | 1003 | Marko | FD | NULL NULL | | |
2020-06-07 | 1003 | Marko | FD | NULL NULL | | |
2020-06-06 | 1004 | Ivan | FD | NULL NULL | | |
2020-06-07 | 1004 | Ivan | FD | NULL NULL | | |
2020-06-06 | 1005 | Marta | FD | NULL NULL | | |
2020-06-07 | 1005 | Marta | FD | NULL NULL | | |
2020-06-07 | 1006 | Smiljan | FD | NULL NULL | | |
dodao sam na tvoj upot ORDER BY r1.date ASC, s1.id_office ASC
Tako da mi sortira po datumu i office
rezultat:
plava treba
date Ascending 1 | 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-01 | 1004 | 20 | 2 | 05:30:00 |
2020-06-01 | 1005 | 320 | 2 | 11:30:00 |
2020-06-01 | 1006 | 620 | 2 | 17:30:00 |
2020-06-01 | 1007 | 30 | 3 | 06:00:00 |
2020-06-01 | 1008 | 330 | 3 | 12:00:00 |
2020-06-01 | 1009 | 630 | 3 | 18:00:00 |
2020-06-02 | 1002 | 10 | 1 | 05:00:00 |
2020-06-02 | 1003 | 310 | 1 | 11:00:00 |
2020-06-02 | 1004 | 610 | 1 | 17:00:00 |
2020-06-02 | 1005 | 20 | 2 | 05:30:00 |
2020-06-02 | 1006 | 320 | 2 | 11:30:00 |
2020-06-02 | 1007 | 620 | 2 | 17:30: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 | 1003 | 10 | 1 | 05:00:00 |
2020-06-03 | 1004 | 310 | 1 | 11:00:00 |
2020-06-03 | 1005 | 610 | 1 | 17:00:00 |
2020-06-03 | 1008 | 610 | 1 | 17:00:00 |
2020-06-03 | 1006 | 20 | 2 | 05:30:00 |
2020-06-03 | 1007 | 320 | 2 | 11:30: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 | 1004 | 10 | 1 | 05:00:00 |
2020-06-04 | 1005 | 310 | 1 | 11:00:00 |
2020-06-04 | 1006 | 610 | 1 | 17:00:00 |
2020-06-04 | 1007 | 20 | 2 | 05:30:00 |
2020-06-04 | 1008 | 320 | 2 | 11:30:00 |
2020-06-04 | 1009 | 620 | 2 | 17:30: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 | 1005 | 10 | 1 | 05:00:00 |
2020-06-05 | 1006 | 310 | 1 | 11:00:00 |
2020-06-05 | 1007 | 610 | 1 | 17: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-05 | 1002 | 30 | 3 | 06:00:00 |
2020-06-05 | 1003 | 330 | 3 | 12:00:00 |
2020-06-05 | 1004 | 630 | 3 | 18:00:00 |
2020-06-06 | 1002 | FD | NULL NULL | |
2020-06-06 | 1003 | FD | NULL NULL | |
2020-06-06 | 1004 | FD | NULL NULL | |
2020-06-06 | 1005 | FD | NULL NULL | |
2020-06-06 | 1006 | 10 | 1 | 05:00:00 |
2020-06-06 | 1007 | 310 | 1 | 11:00:00 |
2020-06-06 | 1008 | 610 | 1 | 17:00: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 | |
2020-06-07 | 1002 | FD | NULL NULL | |
2020-06-07 | 1003 | FD | NULL NULL | |
2020-06-07 | 1004 | FD | NULL NULL | |
2020-06-07 | 1005 | FD | NULL NULL | |
2020-06-07 | 1006 | FD | NULL NULL | |
2020-06-07 | 1007 | 10 | 1 | 06:00:00 |
2020-06-07 | 1008 | 310 | 1 | 12:00:00 |
2020-06-07 | 1009 | 610 | 1 | 18:00:00 |
znaci ovo treba ostati nakon upita:
date Ascending 1 | 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 | |
Gjoreski , ti samo daj upit a ja cu isprobati i napisati rezultat. Isprobavat ćemo dok ne pogodimo.
Isto vrijedi i za zxz-a. Ti upit a ja rezultat
zivot je moja domovina.
Ovaj post je ureden
3
puta. Posljednja izmjena 09.06.2020 12:01 od strane Avko.