{"id":942,"date":"2023-06-08T12:13:59","date_gmt":"2023-06-08T12:13:59","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=942"},"modified":"2023-06-08T12:15:48","modified_gmt":"2023-06-08T12:15:48","slug":"paringutulemuste-uhendamine","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/paringutulemuste-uhendamine\/","title":{"rendered":"P\u00e4ringutulemuste \u00fchendamine"},"content":{"rendered":"\n<p>Vahel on mugav, kui p\u00e4ringuga saab soovitud tulemuse v\u00f5imalikult t\u00e4pselt ette anda \u2013 et hiljem poleks muretsemist, kuidas \u00fcksikutest l\u00f5ikudest tervet vastust kokku panna. \u00dcheks mooduseks on p\u00e4ringutulemuste \u00fchend \u2013 UNION. Tahtes teha nimekaarte k\u00f5igile lastele ja lemmikloomadele, v\u00f5ib nende nimed kokku liita.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT eesnimi FROM lapsed\nUNION \nSELECT loomanimi FROM lemmikloomad\n<\/pre><\/div>\n\n\n<p>Vastuses oleva tulba nimi v\u00f5etakse esimese p\u00e4ringu j\u00e4rgi. Ja ongi k\u00f5ik erinevad nimed siin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"347\" height=\"395\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-28.png\" alt=\"\" class=\"wp-image-945\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-28.png 347w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-28-264x300.png 264w\" sizes=\"auto, (max-width: 347px) 100vw, 347px\" \/><\/figure>\n\n\n\n<p>Samuti v\u00f5ib mingil p\u00f5hjusel olla soov v\u00e4lja tuua k\u00f5ik tabelis leiduvad arvud. Kaks p\u00e4ringut \u00fchtej\u00e4rge, UNION vahele ning loetelu ongi k\u00e4es.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT pikkus FROM laps_tbl\nUNION \nSELECT synniaasta FROM laps_tbl\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"332\" height=\"411\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-29.png\" alt=\"\" class=\"wp-image-948\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-29.png 332w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-29-242x300.png 242w\" sizes=\"auto, (max-width: 332px) 100vw, 332px\" \/><\/figure>\n\n\n\n<p>Nagu n\u00e4idete p\u00f5hjal aimata sai, l\u00e4hevad UNION k\u00e4su p\u00f5hjal korduvad v\u00e4\u00e4rtused kaduma. Tegemist matemaatilises m\u00f5ttes hulgatehtega, mille tulemusena j\u00e4etakse alles vaid erinevad v\u00e4\u00e4rtused. Tahtes, et ka k\u00f5ik korduvad arvud v\u00f5i s\u00f5nad n\u00e4ha oleksid, selleks sobib kahe p\u00e4ringu vahele panna UNION ALL. Nii n\u00e4eme m\u00f5lema p\u00e4ringu tulemuste summat tervikuna.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT pikkus as arvud FROM laps_tbl\nUNION ALL\nSELECT synniaasta FROM laps_tbl\nORDER BY arvud\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"315\" height=\"466\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-30.png\" alt=\"\" class=\"wp-image-952\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-30.png 315w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-30-203x300.png 203w\" sizes=\"auto, (max-width: 315px) 100vw, 315px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Vahel on mugav, kui p\u00e4ringuga saab soovitud tulemuse v\u00f5imalikult t\u00e4pselt ette anda \u2013 et hiljem poleks muretsemist, kuidas \u00fcksikutest l\u00f5ikudest tervet vastust kokku panna. \u00dcheks mooduseks on p\u00e4ringutulemuste \u00fchend \u2013 UNION. Tahtes teha nimekaarte k\u00f5igile lastele ja lemmikloomadele, v\u00f5ib nende nimed kokku liita. Vastuses oleva tulba nimi v\u00f5etakse esimese p\u00e4ringu j\u00e4rgi. Ja ongi k\u00f5ik erinevad &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/paringutulemuste-uhendamine\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">P\u00e4ringutulemuste \u00fchendamine<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-942","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=942"}],"version-history":[{"count":8,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/942\/revisions"}],"predecessor-version":[{"id":954,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/942\/revisions\/954"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}