{"id":99,"date":"2011-10-02T09:32:19","date_gmt":"2011-10-02T09:32:19","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=99"},"modified":"2011-10-02T09:32:19","modified_gmt":"2011-10-02T09:32:19","slug":"7-rezultatai-tarpe","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=99","title":{"rendered":"7. Rezultatai tarpe&#8230;"},"content":{"rendered":"<p>Duomen\u0173 atrinkimas po WHERE gali dominti, kurie yra tarp<br \/>\nka\u017eko arba yra lygus atskiroms vert\u0117ms. Kelios s\u0105lygos gali b\u016bti apra\u0161ytos su<br \/>\ns\u0105lygomis AND arba OR. Visgi tokios SQL u\u017eklausos pasidaro labai ilgos ir<br \/>\nsunkiai skaitomos, kurias galima padaryti daug ai\u0161kesnes pasinaudojant IN ir<br \/>\nBETWEEN. Pirmiausia pa\u017ei\u016br\u0117kime \u012f paprast\u0105 form\u0105 ir jos galim\u0105 supaprastint\u0105<br \/>\natitikmen\u012f.<\/p>\n<p>Pavyzdys, kur atrenkame kainas, kurios tarp 40.00 ir 22.00:<\/p>\n<blockquote><p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina &gt; 22.00 AND kaina &lt; 40.00;<\/p><\/blockquote>\n<p>Toki\u0105 u\u017eklaus\u0105 galime perra\u0161yti i\u0161karto su mintim \u201etarpe\u201c,<br \/>\ntiksliau su raktiniais \u017eod\u017eiai BETWEEN \u201epirma vert\u0117\u201c AND \u201eantra vert\u0117\u201c:<\/p>\n<blockquote><p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina BETWEEN 22.00 AND \u00a040.00;<\/p><\/blockquote>\n<p>Kitas atvejis, jeigu domina tik konkre\u010dios vert\u0117s. \u010cia<br \/>\ngalima pasinaudoti \u012fprastu b\u016bdu, t.y. su OR operatoriais:<\/p>\n<blockquote><p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina = 22.00 OR kaina = 40.00 OR kaina=28.00;<\/p><\/blockquote>\n<p>Arba galima nurodyti, kad palygintu SQL serveris su visomis<br \/>\nIN skliaustelyje i\u0161vardintomis vert\u0117mis:<\/p>\n<blockquote><p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina IN (22.00, 40.00 , 28.00);<\/p><\/blockquote>\n<p>Taip pat yra ir atvirk\u0161\u010diais variantas\u00a0 nelygu. Paprasta SQL logika b\u016bt\u0173:<\/p>\n<blockquote><p>SELECT preke, kaina<br \/>\nFROM uzsakymu_sarasas<br \/>\nWHERE kaina != 22.00 OR kaina != 40.00 OR kaina!=28.00;<\/p><\/blockquote>\n<p>Tuo tarpu su NOT IN:<\/p>\n<blockquote><p>SELECT preke, kaina<br \/>\nFROM uzsakymu_sarasas WHERE kaina NOT IN (22.00, 40.00 , 28.00);<\/p><\/blockquote>\n<p>BETWEEN AND ir (NOT) IN leid\u017eia para\u0161yti daug trumpiau ir ai\u0161kiau didelio kiekio s\u0105lygas.<\/p>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. I\u0161rinkite pardavimo laik\u0105, prek\u0117s pavadinim\u0105 ir kain\u0105, kuri\u0173 pardavimo kaina buvo nuo 10.00 iki 80.00.<br \/>\n2. I\u0161rinkite vard\u0105, pavard\u0119, miest\u0105 t\u0173 \u017emoni\u0173, kurie yra viename i\u0161 \u0161i\u0173 rajon\u0173: Vilniaus, Ma\u017eeiki\u0173 ar Klaip\u0117dos.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 atrinkimas po WHERE gali dominti, kurie yra tarp ka\u017eko arba yra lygus atskiroms vert\u0117ms. Kelios s\u0105lygos gali b\u016bti apra\u0161ytos su s\u0105lygomis AND arba OR. Visgi tokios SQL u\u017eklausos pasidaro labai ilgos ir sunkiai skaitomos, kurias galima padaryti daug ai\u0161kesnes pasinaudojant IN ir BETWEEN. Pirmiausia pa\u017ei\u016br\u0117kime \u012f paprast\u0105 form\u0105 ir jos galim\u0105 supaprastint\u0105 atitikmen\u012f. Pavyzdys, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-99","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=99"}],"version-history":[{"count":2,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/99\/revisions"}],"predecessor-version":[{"id":101,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/99\/revisions\/101"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/13"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}