Avko |
08.06.2020 12:34 |
Predmet:Re: SQL upiti
Citiraj Gjoreski:PreuzmiIzvorni kôd (SQL):SELECT *
FROM tbl_calendar t1
INNER JOIN tbl_citydepartmentoffice t2 ON t1.id_cityDepartmentOffice=t2.Id_cityDeparmentOffice
INNER JOIN tbl_schedule t3 ON t2.id_department = t3.id_department
INNER JOIN (SELECT A.DATE,B.id_office,B.id_department
FROM tbl_schedule A
INNER JOIN tbl_citydepartmentoffice B ON B.id_department=A.id_department
WHERE A.id_employees=1001)
tt ON tt.DATE=t3.DATE AND tt.id_department=t2.id_department AND tt.id_office=t2.id_office
Nažalost nije.
Ja sam malo isprobavao. Imam upit za sve employees i sve datume:
PreuzmiIzvorni kôd (Text):SELECT r1.date, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
FROM tbl_schedule as r1
INNER JOIN tbl_calendar AS k1 ON r1.date = k1.date
INNER JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
WHERE r1.date >= DATE('2020-06-01')
ORDER BY r1.date ASC, r1.id_department ASC
limit 0,100;
ako dodam u WHERE AND r1.id_employees=1001, pokaze mi samo za 1001 za sve datume a nevidim druge employeese. Isto tako ne vidim za 7.7. 1001 je FD to mi ne pokaze.
Mozda bi trebalo nesto sa IF THEN ELSE. Ako je id_department > 0 (IsNumeric) onda izvrši upit a ako nije onda neznam.
Zakompliciro sam previše. Ja sam razmisljao da uzmem za Vaska upit pa sa php stavim u array i onda idem od 1 do ubound(array) i pretrazujem za svaki dan po office za ostale. To mi jedino sada pada na pamet. |
Avko |
08.06.2020 12:41 |
Predmet:Re: SQL upiti
Citiraj zxz:PreuzmiIzvorni kôd (Text):SELECT r.name
,rv.Date
,rv.id_department
,CONCAT(rv.id_department,rv.Date) as kljuc
FROM tbl_schedule rv
INNER JOIN tbl_employees as r ON rv.id_employees=r.id_employees
WHERE CONCAT(rv.id_department,rv.Date)
IN (SELECT
CONCAT(rv.id_department,rv.Date) as kljuc
FROM tbl_schedule as rv WHERE id_employees=1001
)
AND
rv.id_employees<>1001
pod uslovom da sam pogodio polje broj kancelarija.
U mom slucaju je to id_department
U ovome tvome upitu pokazo mi je sve zaposlenike koji su 7.6. imali Fraj dan s time da je izuzet Vasko 1001 |
zxz |
08.06.2020 12:51 |
Predmet:Re: SQL upiti
Nije zakoplicirano ali nije dobro objanjeno.
Ja neznam engleski pa mi dodatno komlikuje.
Ja evo naprimjer neznam sa sigurnoscu u koju tabelu se upisuje rad.
Znaci treba opisati tabele i imena polja.
Ja se bar nemogu snaci.
Nije problem upita nego je problem znacenje polja.
Evo vidim odgovorio si mi da i dobio samo slobodne dane za te ljude.
To je pokazao iz razloga sto neznam koja je tabele za unos rada.
Jeli id_department broj kancelarije |
Avko |
08.06.2020 13:43 |
Predmet:Re: SQL upiti
Raspored
------------
id zaposlenik
id zgrada
datum
raspored nam govori u kojoj zgradi zaposlenik radi za odredeni datum.
grad
---------
id grad
id kancelarija
id zgrada
u gradu imamo zgrade sa kancelarijama
Kalendar
-----------
datum
id grad
zaposlenik
-------------
id zaposlenik
ime
Kancelarija u zgradi ne radi uvijek isto. Subotom rade samo 2 zaposlenika u kancelariji u kojoj radnim danom rade 3 zaposlenika. Koliko ce smjena biti u nekoj kancelariji odreduje se preko tbl grad.
Zgradi se mijenja id prelaskom na subotu ili nedjelju pa tako kancelarija id 1 u id zgradi 10 radnim danom pocinje raditi od 5 dok nedjeljom pocinje raditi od 6. |
zxz |
08.06.2020 15:47 |
Predmet:Re: SQL upiti
PreuzmiIzvorni kôd (MySQL):
,r.name
,rv.id_department
,o.id_office
,CONCAT(k.id_cityDepartmentOffice ,rv.id_department ) as kljuc
INNER JOIN tbl_citydepartmentoffice as o ON o.Id_cityDeparmentOffice =k.id_cityDepartmentOffice
AND rv.id_department =o.id_department
INNER JOIN tbl_citydepartmentoffice as o ON rv.id_department =o.id_department
WHERE rv.id_employees =1001
)
rv.id_employees<>1001
Da budem iskren nisam dovoljno ni procitao.
Gore sam mislio da su prve dvije tabele 1 na 1.
Ovdje je problem kljuca za cetvrtu tabelu i ako je on
IdCityDepartmentOffice i
IdDepartment
onda bi ovo rjesenje trebalo biti dobro.
Nisam testirao. |
Gjoreski |
08.06.2020 19:36 |
Predmet:Re: SQL upiti
Ja opet ne razumem nista sve radim napamet.
Mozemo li ovako:
Prvo uradi cu jedan sql koj ce nam iscitati sve zapise koje nam trebaju a kasnije cemo dodati uslov,evo SQL pogledaj jel ima on sve podatke koje nam trebaju ?
PreuzmiIzvorni kôd (SQL):SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
FROM tbl_schedule AS r1
INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
|
Avko |
09.06.2020 09:25 |
Predmet:Re: SQL upiti
Citiraj zxz:PreuzmiIzvorni kôd (MySQL):
,r.name
,rv.id_department
,o.id_office
,CONCAT(k.id_cityDepartmentOffice ,rv.id_department ) as kljuc
INNER JOIN tbl_citydepartmentoffice as o ON o.Id_cityDeparmentOffice =k.id_cityDepartmentOffice
AND rv.id_department =o.id_department
INNER JOIN tbl_citydepartmentoffice as o ON rv.id_department =o.id_department
WHERE rv.id_employees =1001
)
rv.id_employees<>1001
Da budem iskren nisam dovoljno ni procitao.
Gore sam mislio da su prve dvije tabele 1 na 1.
Ovdje je problem kljuca za cetvrtu tabelu i ako je on
IdCityDepartmentOffice i
IdDepartment
onda bi ovo rjesenje trebalo biti dobro.
Nisam testirao.
id_employees | name | Date | id_department | id_office | kljuc | | 1002 | Luka | 2020-06-01 | 310 | 1 | 106310 | | 1003 | Marko | 2020-06-01 | 610 | 1 | 106610 | | 1004 | Ivan | 2020-06-01 | 20 | 2 | 10620 | | 1005 | Marta | 2020-06-01 | 320 | 2 | 106320 | | 1006 | Smiljan | 2020-06-01 | 620 | 2 | 106620 | | 1007 | Mitar | 2020-06-01 | 30 | 3 | 10630 | | 1008 | Ahmed | 2020-06-01 | 330 | 3 | 106330 | | 1009 | Aleksandar | 2020-06-01 | 630 | 3 | 106630 | | 1002 | Luka | 2020-06-02 | 10 | 1 | 10610 | | 1003 | Marko | 2020-06-02 | 310 | 1 | 106310 | | 1004 | Ivan | 2020-06-02 | 610 | 1 | 106610 | | 1005 | Marta | 2020-06-02 | 20 | 2 | 10620 | | 1006 | Smiljan | 2020-06-02 | 320 | 2 | 106320 | | 1007 | Mitar | 2020-06-02 | 620 | 2 | 106620 | | 1008 | Ahmed | 2020-06-02 | 30 | 3 | 10630 | | 1009 | Aleksandar | 2020-06-02 | 330 | 3 | 106330 | | 1002 | Luka | 2020-06-03 | 630 | 3 | 106630 | | 1003 | Marko | 2020-06-03 | 10 | 1 | 10610 | | 1004 | Ivan | 2020-06-03 | 310 | 1 | 106310 | | 1005 | Marta | 2020-06-03 | 610 | 1 | 106610 | | 1006 | Smiljan | 2020-06-03 | 20 | 2 | 10620 | | 1007 | Mitar | 2020-06-03 | 320 | 2 | 106320 | | 1008 | Ahmed | 2020-06-03 | 610 | 1 | 106610 | | 1009 | Aleksandar | 2020-06-03 | 30 | 3 | 10630 | | 1002 | Luka | 2020-06-04 | 330 | 3 | 106330 | | 1003 | Marko | 2020-06-04 | 630 | 3 | 106630 | | 1004 | Ivan | 2020-06-04 | 10 | 1 | 10610 | | 1005 | Marta | 2020-06-04 | 310 | 1 | 106310 | | 1006 | Smiljan | 2020-06-04 | 610 | 1 | 106610 | | 1007 | Mitar | 2020-06-04 | 20 | 2 | 10620 | | 1008 | Ahmed | 2020-06-04 | 320 | 2 | 106320 | | 1009 | Aleksandar | 2020-06-04 | 620 | 2 | 106620 | | 1002 | Luka | 2020-06-05 | 30 | 3 | 10630 | | 1003 | Marko | 2020-06-05 | 330 | 3 | 106330 | | 1004 | Ivan | 2020-06-05 | 630 | 3 | 106630 | | 1005 | Marta | 2020-06-05 | 10 | 1 | 10610 | | 1006 | Smiljan | 2020-06-05 | 310 | 1 | 106310 | | 1007 | Mitar | 2020-06-05 | 610 | 1 | 106610 | | 1008 | Ahmed | 2020-06-05 | 20 | 2 | 10620 | | 1009 | Aleksandar | 2020-06-05 | 320 | 2 | 106320 | | 1006 | Smiljan | 2020-06-06 | 10 | 1 | 60610 | | 1007 | Mitar | 2020-06-06 | 310 | 1 | 606310 | | 1008 | Ahmed | 2020-06-06 | 610 | 1 | 606610 | | 1009 | Aleksandar | 2020-06-06 | 20 | 2 | 60620 | | 1007 | Mitar | 2020-06-07 | 10 | 1 | 70610 | | 1008 | Ahmed | 2020-06-07 | 310 | 1 | 706310 | | 1009 | Aleksandar | 2020-06-07 | 610 | 1 | 706610 | |
Pokazuje sve osim Vasko 1001, nije ni točno.
ovako bi trebalo izgledati:
date | id_employees | name | id_department | id_office | startTime | | 2020-06-01 | 1001 | Vasko | 10 | 1 | 05:00:00 | | 2020-06-01 | 1002 | Luka | 310 | 1 | 11:00:00 | | 2020-06-01 | 1003 | Marko | 610 | 1 | 17:00:00 | | 2020-06-02 | 1008 | Ahmed | 30 | 3 | 06:00:00 | | 2020-06-02 | 1009 | Aleksandar | 330 | 3 | 12:00:00 | | 2020-06-02 | 1001 | Vasko | 630 | 3 | 18:00:00 | | 2020-06-03 | 1009 | Aleksandar | 30 | 3 | 06:00:00 | | 2020-06-03 | 1001 | Vasko | 330 | 3 | 12:00:00 | | 2020-06-03 | 1002 | Luka | 630 | 3 | 18:00:00 | | 2020-06-04 | 1001 | Vasko | 30 | 3 | 06:00:00 | | 2020-06-04 | 1002 | Luka | 330 | 3 | 12:00:00 | | 2020-06-04 | 1003 | Marko | 630 | 3 | 18:00:00 | | 2020-06-05 | 1008 | Ahmed | 20 | 2 | 05:30:00 | | 2020-06-05 | 1009 | Aleksandar | 320 | 2 | 11:30:00 | | 2020-06-05 | 1001 | Vasko | 620 | 2 | 17:30:00 | | 2020-06-06 | 1009 | Aleksandar | 20 | 2 | 09:00:00 | | 2020-06-06 | 1001 | Vasko | 320 | 2 | 15:00:00 | | 2020-06-07 | 1001 | Vasko | FD | | | | |
Avko |
09.06.2020 09:28 |
Predmet:Re: SQL upiti
Citiraj Gjoreski:Ja opet ne razumem nista sve radim napamet.
Mozemo li ovako:
Prvo uradi cu jedan sql koj ce nam iscitati sve zapise koje nam trebaju a kasnije cemo dodati uslov,evo SQL pogledaj jel ima on sve podatke koje nam trebaju ?
PreuzmiIzvorni kôd (SQL):SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
FROM tbl_schedule AS r1
INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
evo ištitalo je sve:
date | id_employees | name | id_department | id_office | startTime | | 2020-06-01 | 1001 | Vasko | 10 | 1 | 05:00:00 | | 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 | | 2020-06-04 | 1001 | Vasko | 30 | 3 | 06:00:00 | | 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 | | 2020-06-03 | 1009 | Aleksandar | 30 | 3 | 06:00:00 | | 2020-06-01 | 1002 | Luka | 310 | 1 | 11:00:00 | | 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 | | 2020-06-03 | 1001 | Vasko | 330 | 3 | 12:00:00 | | 2020-06-04 | 1002 | Luka | 330 | 3 | 12:00:00 | | 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 | | 2020-06-01 | 1003 | Marko | 610 | 1 | 17:00:00 | | 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 | | 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 | | 2020-06-03 | 1002 | Luka | 630 | 3 | 18:00:00 | | 2020-06-04 | 1003 | Marko | 630 | 3 | 18:00:00 | | 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 | | 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 | | | 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 | | | |
Gjoreski |
09.06.2020 10:11 |
Predmet:Re: SQL upiti
Ako je sve uredu ako imamo sva sta nam treba mozes li sad da nam kazes sta treba da se izdvoi iz ova tabela a sta ne treba biti tu pa da uradimo uslov |
Avko |
09.06.2020 11:52 |
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 |