U\u017eklausa SELECT skirta u\u017eklausti duomen\u0173 baz\u0119 ir gauti
\nduomenis, kurie atitinka nurodytus kriterijus.<\/p>\n
U\u017eklausa SELECT turi 5 pagrindines sudedam\u0105sias dalis. FROM
\ndalis yra privaloma. Kitos dalys nurodo savybes, parametrus ir pan.\u00a0 Apie t\u0173 dali\u0173 detalesnes galimybes bus
\ntolesn\u0117se pamokose. Dalys apra\u0161ytos SELECT u\u017eklausos formate:<\/p>\n
SELECT [ALL | DISTINCT] stulpelisnr1 [,stulpelisnr2]
\nFROM lentel\u0117nr1 [,lentel\u0117nr2]
\n[WHERE “s\u0105lygos”]
\n[GROUP BY “stulpeli\u0173-s\u0105ra\u0161as”]
\n[HAVING “s\u0105lygos\u201c]
\n[ORDER BY ” stulpeli\u0173-s\u0105ra\u0161as ” [ASC | DESC] ]<\/p>\n[] \u2013 nerodoma pagal poreik\u012f<\/p><\/blockquote>\n
Pavyzdys su lentele \u201eSkai\u010diai\u201c<\/p>\n
\n\n
\n \n SK1<\/strong><\/p>\n<\/td>\n
\n SK2<\/strong><\/p>\n<\/td>\n
\n SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n 1<\/p>\n<\/td>\n
\n I<\/p>\n<\/td>\n
\n Vienas<\/p>\n<\/td>\n<\/tr>\n
\n \n 1<\/p>\n<\/td>\n
\n I<\/p>\n<\/td>\n
\n Vienas<\/p>\n<\/td>\n<\/tr>\n
\n \n 2<\/p>\n<\/td>\n
\n II<\/p>\n<\/td>\n
\n Du<\/p>\n<\/td>\n<\/tr>\n
\n \n 3<\/p>\n<\/td>\n
\n III<\/p>\n<\/td>\n
\n Trys<\/p>\n<\/td>\n<\/tr>\n
\n \n 4<\/p>\n<\/td>\n
\n IV<\/p>\n<\/td>\n
\n Keturi<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
SQL u\u017eklausa:<\/p>\n
SELECT SK2, SKAICIUS WHERE SK1>2;<\/p><\/blockquote>\n
Rezultatas bus:<\/p>\n
\n\n
\n \n SK1<\/strong><\/p>\n<\/td>\n
\n SK2<\/strong><\/p>\n<\/td>\n
\n SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n 3<\/p>\n<\/td>\n
\n III<\/p>\n<\/td>\n
\n Trys<\/p>\n<\/td>\n<\/tr>\n
\n \n 4<\/p>\n<\/td>\n
\n IV<\/p>\n<\/td>\n
\n Keturi<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Palyginimo operatoriai<\/p>\n
\n\n
\n \n Operatorius<\/strong><\/p>\n<\/td>\n
\n Apra\u0161ymas<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n =<\/p>\n<\/td>\n
\n Lygu<\/p>\n<\/td>\n<\/tr>\n
\n \n ><\/p>\n<\/td>\n
\n Daugiau negu<\/p>\n<\/td>\n<\/tr>\n
\n \n <<\/p>\n<\/td>\n
\n Ma\u017eiau negu<\/p>\n<\/td>\n<\/tr>\n
\n \n >=<\/p>\n<\/td>\n
\n Daugiau u\u017e arba lygu<\/p>\n<\/td>\n<\/tr>\n
\n \n <=<\/p>\n<\/td>\n
\n Ma\u017eiau u\u017e arba lygu<\/p>\n<\/td>\n<\/tr>\n
\n \n <><\/p>\n<\/td>\n
\n Nelygu<\/p>\n<\/td>\n<\/tr>\n
\n \n !=<\/p>\n<\/td>\n<\/tr>\n
\n \n LIKE<\/p>\n<\/td>\n
\n Teksto palyginimas<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
SQL u\u017eklausa:<\/p>\n
SELECT SK2, SKAICIUS WHERE SKAICIUS LIKE `%u%`;<\/p><\/blockquote>\n
Rezultatas bus:<\/p>\n
\n\n
\n \n SK1<\/strong><\/p>\n<\/td>\n
\n SK2<\/strong><\/p>\n<\/td>\n
\n SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n 2<\/p>\n<\/td>\n
\n II<\/p>\n<\/td>\n
\n Du<\/p>\n<\/td>\n<\/tr>\n
\n \n 4<\/p>\n<\/td>\n
\n IV<\/p>\n<\/td>\n
\n Keturi<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Raktinis \u017eodis DISTINCT nurodo, kad rezultat\u0173 eilut\u0117s
\nprivalo b\u016bti skirtingos. Tuo tarpu ALL rei\u0161kia, kad visos eilut\u0117s turi b\u016bti
\nrodomos. ALL yra numatytasis parametras.<\/p>\nSQL u\u017eklausa:<\/p>\n
SELECT SK1, SK2, SKAICIUS WHERE SK1 =\u00a0 1;<\/p><\/blockquote>\n
Rezultatas:<\/p>\n
\n\n
\n \n SK1<\/strong><\/p>\n<\/td>\n
\n SK2<\/strong><\/p>\n<\/td>\n
\n SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n 1<\/p>\n<\/td>\n
\n I<\/p>\n<\/td>\n
\n Vienas<\/p>\n<\/td>\n<\/tr>\n
\n \n 1<\/p>\n<\/td>\n
\n I<\/p>\n<\/td>\n
\n Vienas<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
SQL u\u017eklausa:<\/p>\n
SELECT DISTINCT SK1, SK2, SKAICIUS WHERE SK1 =\u00a0 1;<\/p><\/blockquote>\n
Rezultatas:<\/p>\n
\n\n
\n \n SK1<\/strong><\/p>\n<\/td>\n
\n SK2<\/strong><\/p>\n<\/td>\n
\n SKAICIUS<\/strong><\/p>\n<\/td>\n<\/tr>\n
\n \n 1<\/p>\n<\/td>\n
\n I<\/p>\n<\/td>\n
\n Vienas<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
<\/p>\n
Pasikartojimo u\u017eduotys<\/strong><\/p>\n
1. Pa\u017ei\u016br\u0117ti visus duomenis lentel\u0117s uzsakymu_sarasas<\/em>.
\n2. I\u0161 lentel\u0117s uzsakymu<\/em>_sarasas<\/em> i\u0161rinkti visus u\u017esakymus, kur
\nkliento numeris (klientoid) yra 10449. Pateikti \u012f ekran\u0105 klientoid, preke ir
\nkaina.
\n3. Pateikti visus duomenis i\u0161 lentel\u0117s uzsakymu_sarasas<\/em>,
\nkur buvo u\u017esakytos palapin\u0117s<\/strong>.
\n4. \u00a0Pateikti \u012f ekran\u0105 klientoid, u\u017esakymo_laikas
\nir preke i\u0161 lentel\u0117s uzsakymu_sarasas<\/em>,
\nkur prekes stulpelis prasideda reide \u201eS\u201c.
\n5. I\u0161rinkti skirtingas prekes i\u0161 lentel\u0117s uzsakymu_sarasas<\/em>.
\nPrek\u0117s turi nesikartoti.
\n6. Susigalvoti dar 3 savo u\u017eklausas ir jas \u012fvykdyti.<\/p>\n","protected":false},"excerpt":{"rendered":"U\u017eklausa SELECT skirta u\u017eklausti duomen\u0173 baz\u0119 ir gauti duomenis, kurie atitinka nurodytus kriterijus. U\u017eklausa SELECT turi 5 pagrindines sudedam\u0105sias dalis. FROM dalis yra privaloma. Kitos dalys nurodo savybes, parametrus ir pan.\u00a0 Apie t\u0173 dali\u0173 detalesnes galimybes bus tolesn\u0117se pamokose. Dalys apra\u0161ytos SELECT u\u017eklausos formate: SELECT [ALL | DISTINCT] stulpelisnr1 [,stulpelisnr2] FROM lentel\u0117nr1 [,lentel\u0117nr2] [WHERE “s\u0105lygos”] […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":13,"menu_order":1,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-19","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/19","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=19"}],"version-history":[{"count":4,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/19\/revisions"}],"predecessor-version":[{"id":79,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/19\/revisions\/79"}],"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=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}