{"id":1566,"date":"2021-04-04T21:27:34","date_gmt":"2021-04-04T20:27:34","guid":{"rendered":"https:\/\/ssntb.org\/mirozaric\/?p=1566"},"modified":"2021-04-04T21:27:34","modified_gmt":"2021-04-04T20:27:34","slug":"upiti","status":"publish","type":"post","link":"https:\/\/ssntb.org\/mirozaric\/2021\/04\/04\/upiti\/","title":{"rendered":"Upiti"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Da bi bilo jednostavnije razumjevanje upita prati\u0107emo jedan primjer. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Koristi\u0107emo dvije tabele \u2013 tabelu RADNIK u kojoj su podaci sa donje slike i SEKTOR u kojoj se nalaze podaci \u0161ifru i naziv sektora. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pretpostavi\u0107emo dalje da nas interesuje odgovor na slede\u0107e pitanje: izlistati spisak radnika, ro\u0111enih nakon 01.01.1965. sa nazivima sektora u kojima rade, sortirano po prezimenu radnika.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"822\" height=\"590\" src=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-3.png\" alt=\"\" class=\"wp-image-1567\" srcset=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-3.png 822w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-3-300x215.png 300w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-3-768x551.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Da bismo dobili odgovor moramo postaviti odgovaraju\u0107i upit (Query). Upit se mo\u017ee postaviti tako \u0161to \u0107e se napisati odgovaraju\u0107a SQL re\u010denica ili tako \u0161to \u0107e se koristiti Wizard. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Da vidimo kako to ide preko Wizarda. U tab \u2013u <strong>Create<\/strong> postoji dugme <strong>Query Wizard<\/strong>. Kliknuv\u0161i na njega pokre\u0107e se alat tj proces u kome prvo treba da izaberemo tabele iz kojih \u0107emo \u201eizvla\u010diti\u201c podatke, a kad to uradimo slijedi odre\u0111ivanje tabele u donjem dijelu prozora, kao na slede\u0107oj slici.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"839\" height=\"603\" src=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-4.png\" alt=\"\" class=\"wp-image-1568\" srcset=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-4.png 839w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-4-300x216.png 300w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-4-768x552.png 768w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">U prvom redu <strong>Field<\/strong> biramo redom polja iz tabela koja nam trebaju. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">U drugom redu <strong>Table<\/strong> su zapisane tabele iz kojih su ta polja. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">U tre\u0107em redu <strong>Sort<\/strong> biramo da li \u0107emo i po kom polju da radimo sortiranje (koje mo\u017ee biti rastu\u0107e i opadaju\u0107e; kako je slovo a \u201emanje vrenosti\u201c nego b ako ho\u0107emo ure\u0111enje po abecedi onda \u0107emo ostaviti Ascending). <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u010cetvrti red <strong>Show<\/strong> slu\u017ei da biramo da li \u0107e polje biti prikazano u rezultatu upita ili ne. Ako ne\u0107emo \u2013 poni\u0161timo \u010dek znak. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dolazimo do zavr\u0161nog red <strong>Criteria <\/strong>koji odgovara WHERE klauzuli u SQL upitu. Uslovom koji ovdje zadamo vr\u0161imo izdvajanje (filtraciju) samo onih slogova iz tabele koji zadovoljavaju uslov. Kada smo zavr\u0161ili sa odre\u0111ivanjem uslova, snimi\u0107emo upit pod nekim imenom.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Sada preostaje da se upit pokrene (open). Rezultat je kao na slede\u0107oj slici.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"467\" src=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-5.png\" alt=\"\" class=\"wp-image-1569\" srcset=\"https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-5.png 652w, https:\/\/ssntb.org\/mirozaric\/wp-content\/uploads\/2021\/04\/image-5-300x215.png 300w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Da bi bilo jednostavnije razumjevanje upita prati\u0107emo jedan primjer. Koristi\u0107emo dvije tabele \u2013 tabelu RADNIK u kojoj su podaci sa donje slike i SEKTOR u kojoj se nalaze podaci \u0161ifru i naziv sektora. Pretpostavi\u0107emo dalje da nas interesuje odgovor na slede\u0107e pitanje: izlistati spisak radnika, ro\u0111enih nakon 01.01.1965. sa nazivima sektora u kojima rade, sortirano&hellip; <br \/> <a class=\"button small blue\" href=\"https:\/\/ssntb.org\/mirozaric\/2021\/04\/04\/upiti\/\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1566","post","type-post","status-publish","format-standard","hentry","category-18"],"_links":{"self":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/comments?post=1566"}],"version-history":[{"count":1,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1566\/revisions"}],"predecessor-version":[{"id":1570,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/posts\/1566\/revisions\/1570"}],"wp:attachment":[{"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/media?parent=1566"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/categories?post=1566"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssntb.org\/mirozaric\/wp-json\/wp\/v2\/tags?post=1566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}