{"id":91,"date":"2011-10-01T22:06:34","date_gmt":"2011-10-01T22:06:34","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=91"},"modified":"2011-10-01T22:06:34","modified_gmt":"2011-10-01T22:06:34","slug":"5-duomenu-rusiavimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=91","title":{"rendered":"5. Duomen\u0173 r\u016b\u0161iavimas"},"content":{"rendered":"<p>Duomen\u0173 r\u016b\u0161iavimas yra atliekamas su komanda ORDER BY, kuri<br \/>\natliekama pagal nurodytus stulpelius. Strukt\u016bra tokia:<\/p>\n<blockquote><p>SELECT stulpelisnr1 FROM lentele ORDER BY stulelisnr1 [ASC|DESC]<br \/>\n[, stulelisnr2 [ASC|DESC]];<\/p>\n<p>[] \u2013 pasirinktinai<\/p>\n<p>ASC \u2013 skirta sur\u016b\u0161iuoti did\u0117jimo tvarka.<\/p>\n<p>DESC \u2013 skirta sur\u016b\u0161iuoti ma\u017e\u0117jimo tvarka.<\/p><\/blockquote>\n<p>Pavyzd\u017eiui atrinkime prekes, kuri\u0173 u\u017esakyta buvo daugiau nei<br \/>\nvien\u0105 kart\u0105 ir jas i\u0161r\u016b\u0161iuokime ma\u017e\u0117jimo tvarka:<\/p>\n<blockquote><p>SELECT preke FROM uzsakymu_sarasas WHERE kiekis &gt; 1 ORDER BY preke DESC;<\/p><\/blockquote>\n<p><strong>U\u017eduotys<\/strong><\/p>\n<p>1. I\u0161rinkite vard\u0105, pavard\u0119 ir miest\u0105 vis\u0173 klient\u0173, o rezultat\u0105 i\u0161r\u016b\u0161iuokite did\u0117jimo tvarka pagal pavard\u0119.<br \/>\n2. Atlikti 1 u\u017eduot\u012f, tik rezultat\u0105 i\u0161r\u016b\u0161iuoti ma\u017e\u0117jimo tvarka.<br \/>\n3. I\u0161rinkti visas prekes, kuri\u0173 kaina didesn\u0117 nei 10.00, o rezultat\u0105 pateikti did\u0117jimo tvarka.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 r\u016b\u0161iavimas yra atliekamas su komanda ORDER BY, kuri atliekama pagal nurodytus stulpelius. Strukt\u016bra tokia: SELECT stulpelisnr1 FROM lentele ORDER BY stulelisnr1 [ASC|DESC] [, stulelisnr2 [ASC|DESC]]; [] \u2013 pasirinktinai ASC \u2013 skirta sur\u016b\u0161iuoti did\u0117jimo tvarka. DESC \u2013 skirta sur\u016b\u0161iuoti ma\u017e\u0117jimo tvarka. Pavyzd\u017eiui atrinkime prekes, kuri\u0173 u\u017esakyta buvo daugiau nei vien\u0105 kart\u0105 ir jas i\u0161r\u016b\u0161iuokime ma\u017e\u0117jimo [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-91","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/91","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=91"}],"version-history":[{"count":2,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/91\/revisions"}],"predecessor-version":[{"id":93,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/91\/revisions\/93"}],"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=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}