{"id":94,"date":"2011-10-01T22:20:38","date_gmt":"2011-10-01T22:20:38","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=94"},"modified":"2011-10-01T22:20:52","modified_gmt":"2011-10-01T22:20:52","slug":"6-kelios-salygos","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=94","title":{"rendered":"6. Kelios s\u0105lygos"},"content":{"rendered":"<p>Norint atrinkti pagal kelias s\u0105lygas galima pasinaudoti<br \/>\nloginiu parametru AND, kuris yra WHERE atrinkimo dalis. J\u0173 gali b\u016bti tiek kiek<br \/>\nreikia. Strukt\u016bra yra tokia:<\/p>\n<blockquote><p>SELECT stulpelis1 FROM lentel\u0117 WHERE \u201es\u0105lyganr1\u201c AND \u201es\u0105lyganr2\u201c;<\/p><\/blockquote>\n<p>Pavyzd\u017eiui atrinkime tas prekes, kuri\u0173 kaina yra didesn\u0117 nei<br \/>\n10.00 ir ma\u017eesn\u0117 nei 100.00:<\/p>\n<blockquote><p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina &gt; 10.00 AND kaina &lt; 100.00;<\/p><\/blockquote>\n<p>Kitas operatorius OR, leid\u017eia SQL u\u017eklausas atrinkti pagal<br \/>\nkelias skirtingas s\u0105lygas. Strukt\u016bra yra tokia:<\/p>\n<blockquote><p>SELECT stulpelis1 FROM lentel\u0117 WHERE \u201es\u0105lyganr1\u201c OR \u201es\u0105lyganr2\u201c;<\/p>\n<p>SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina = 40.00 OR kaina = 22.00;<\/p><\/blockquote>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. I\u0161rinkite klient\u0105 (klinetoid), u\u017esakymo laik\u0105 ir prek\u0119, kur u\u017esakytos prek\u0117s buvo ka\u017ekas kita bet ne Liemen\u0117 ar Sk\u0117tis.<br \/>\n2. I\u0161rinkite prek\u0117s, kurios prasideda arba S, arba P, arba F.<br \/>\n3. Sugalvokite 3 SQL u\u017eklausas, kur panaudotum\u0117te AND ir OR.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Norint atrinkti pagal kelias s\u0105lygas galima pasinaudoti loginiu parametru AND, kuris yra WHERE atrinkimo dalis. J\u0173 gali b\u016bti tiek kiek reikia. Strukt\u016bra yra tokia: SELECT stulpelis1 FROM lentel\u0117 WHERE \u201es\u0105lyganr1\u201c AND \u201es\u0105lyganr2\u201c; Pavyzd\u017eiui atrinkime tas prekes, kuri\u0173 kaina yra didesn\u0117 nei 10.00 ir ma\u017eesn\u0117 nei 100.00: SELECT preke, kaina FROM uzsakymu_sarasas WHERE kaina &gt; 10.00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-94","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/94","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=94"}],"version-history":[{"count":4,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/94\/revisions"}],"predecessor-version":[{"id":98,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/94\/revisions\/98"}],"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=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}