{"id":2030,"date":"2024-10-15T22:14:25","date_gmt":"2024-10-15T22:14:25","guid":{"rendered":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/?page_id=2030"},"modified":"2024-10-25T08:03:36","modified_gmt":"2024-10-25T08:03:36","slug":"select-sentences","status":"publish","type":"page","link":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/","title":{"rendered":"SELECT sentences"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong><em>\u0412\u044b\u0431\u0440\u0430\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441 \u0438\u043c\u0435\u043d\u0435\u043c laps<\/em><\/strong><\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt.png?w=382\" alt=\"\" class=\"wp-image-438\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">XAMPP<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE laps(\nlapsID int PRIMARY KEY AUTO_INCREMENT,\nnimi varchar(50),\nvanus int,\nsilmadeVarv varchar(20),\npikkus int,\nsynniLinn varchar(25));\nSELECT * FROM laps;\nINSERT INTO laps(nimi,vanus,silmadeVarv,pikkus,synniLinn)\nValues(&#039;Daria&#039;, 17 , &#039;hall&#039;, 155, &#039;Tallinn&#039;);\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-17.png?w=388\" alt=\"\" class=\"wp-image-477\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><em>Tabeli loom loomine<\/em><\/strong><\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * from loom;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-18.png?w=263\" alt=\"\" class=\"wp-image-480\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>XAMPP<\/strong><\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE TABLE loom(\nloomID int PRIMARY KEY AUTO_INCREMENT,\nloomaNimi varchar(25),\nlapsID int,\nForeign Key (lapsID) references laps(lapsID));\nSELECT * from loom;\nINSERT INTO loom (loomaNimi, lapsID)\nValues (&#039;kass Mura&#039;, 2);\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-19.png?w=221\" alt=\"\" class=\"wp-image-483\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">1. <strong>Tingimused<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>N\u00e4idata ainult nimi ja pikkus<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi, pikkus from laps;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-1.png?w=163\" alt=\"\" class=\"wp-image-441\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-20.png?w=135\" alt=\"\" class=\"wp-image-485\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>N\u00e4idata ainult lapsed, kelle pikkus on suurem kui 175<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi, pikkus\nfrom laps\nWHERE pikkus &gt;=175\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-2.png?w=152\" alt=\"\" class=\"wp-image-443\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-21.png?w=121\" alt=\"\" class=\"wp-image-486\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Sorteerimine<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi, pikkus\nfrom laps\nWHERE pikkus &gt;=175\nORDER by pikkus DESC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-3.png?w=185\" alt=\"\" class=\"wp-image-446\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-22.png?w=198\" alt=\"\" class=\"wp-image-488\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Naitame koik nimed mis algavad K<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi\nFROM laps\nWHERE nimi like &#039;K%&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-4.png?w=93\" alt=\"\" class=\"wp-image-448\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-24.png?w=88\" alt=\"\" class=\"wp-image-491\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Naitame koik nimed mis sisaldavad \u2018e\u2019<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi\nFROM laps\nWHERE nimi like &#039;%e%&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-5.png?w=157\" alt=\"\" class=\"wp-image-450\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-25.png?w=86\" alt=\"\" class=\"wp-image-493\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Vahemik \u2013 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u043a \u2013 between<br>Leiama lapsed vanuses (5;15)<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi, vanus\nFROM laps\nWHERE vanus between 5 and 15;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-6.png?w=167\" alt=\"\" class=\"wp-image-452\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-26.png?w=128\" alt=\"\" class=\"wp-image-495\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. Agregaatfunktsioonid<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SUM()<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MIN()<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MAX()<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>AVG()<\/strong>&nbsp;\u2014 keskmine<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>COUNT()<\/strong>&nbsp;\u2014 \u043a\u043e\u043b \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u043d\u044b\u0445 \u044f\u0447\u0435\u0435\u043a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>ilma between<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect nimi, vanus\nFROM laps\nWHERE vanus &gt;= 5 and vanus &lt;=10;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-7.png?w=171\" alt=\"\" class=\"wp-image-455\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-27.png?w=123\" alt=\"\" class=\"wp-image-496\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Leia keskmine pikkus<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT AVG(pikkus) AS keskmine_pikkus\nFROM laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-8.png?w=168\" alt=\"\" class=\"wp-image-457\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-28.png?w=141\" alt=\"\" class=\"wp-image-498\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Leia summarne vanus<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT SUM(vanus) as &#039;summaarne vanus&#039;\nFROM laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-9.png?w=186\" alt=\"\" class=\"wp-image-458\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-29.png?w=146\" alt=\"\" class=\"wp-image-499\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Leia suurem pikkus ja v\u00e4iksem pikkus<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT MIN(pikkus) as minPikkus,\nMAX(pikkus) as MaxPikkus\nFROM laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-10.png?w=184\" alt=\"\" class=\"wp-image-461\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-30.png?w=199\" alt=\"\" class=\"wp-image-500\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Otsida laste arv, kellel synniLinn on Tallinnas<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT MIN(pikkus) as minPikkus,\nMAX(pikkus) as MaxPikkus\nFROM laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-11.png?w=156\" alt=\"\" class=\"wp-image-462\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-31.png?w=91\" alt=\"\" class=\"wp-image-502\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Select laused kahe tabelite p\u00f5hjal<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM laps, loom\nWHERE laps.lapsID=loom.lapsID\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-12.png?w=579\" alt=\"\" class=\"wp-image-468\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-32.png?w=599\" alt=\"\" class=\"wp-image-503\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>INNER JOIN<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT * FROM laps INNER JOIN loom \nON laps.lapsID=loom.lapsID;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-13.png?w=577\" alt=\"\" class=\"wp-image-469\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-33.png?w=611\" alt=\"\" class=\"wp-image-505\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Ainult vajalikud veerud<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT loom.loomaNimi, laps.nimi \nFROM laps INNER JOIN loom \nON laps.lapsID=loom.lapsID;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-14.png?w=289\" alt=\"\" class=\"wp-image-471\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-34.png?w=190\" alt=\"\" class=\"wp-image-507\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Kasutame preudon\u00fc\u00fcmid<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT lo.loomaNimi, l.nimi\nFROM laps l INNER JOIN loom lo\nON l.lapsID=lo.lapsID \n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-15.png?w=224\" alt=\"\" class=\"wp-image-473\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-35.png?w=205\" alt=\"\" class=\"wp-image-508\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>Tahaks teada kasside omanikud(lapsenimed)<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT lo.loomaNimi, l.nimi\nFROM laps l INNER JOIN loom lo\nON l.lapsID=lo.lapsID \nWHERE lo.loomaNimi like &#039;%koer%&#039;;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-16.png?w=235\" alt=\"\" class=\"wp-image-475\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-36.png?w=151\" alt=\"\" class=\"wp-image-509\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>#6(moodle)<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439<\/em><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE laps\nSET pikkus=pikkus*1.1;\nSELECT * from laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-37.png?w=399\" alt=\"\" class=\"wp-image-512\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-38.png?w=401\" alt=\"\" class=\"wp-image-514\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><em>\u0417\u0430\u0434\u0430\u043d\u0438\u0435: \u0438\u0437\u043c\u0435\u043d\u0438\u0442\u044c \u0441\u0442\u043e\u043b\u0431\u0435\u0446 synnilinn \u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 Tallinn<\/em><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE laps\nSET synnilinn=&#039;Tallinn&#039;;\nSELECT * from laps;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-39.png?w=385\" alt=\"\" class=\"wp-image-517\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-40.png?w=402\" alt=\"\" class=\"wp-image-519\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>#9(moodle)<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>TOP 3 .\u0412\u044b\u0432\u0435\u0441\u0442\u0438 \u0442\u0440\u043e\u0438\u0445 \u0441\u0430\u043c\u044b\u0445 \u0432\u044b\u0441\u043e\u043a\u0438\u0445 \u0434\u0435\u0442\u0435\u0439, \u043e\u0442\u043e\u0431\u0440\u0430\u0437\u0438\u0442\u044c \u0438\u043c\u044f, \u0440\u043e\u0441\u0442.<\/em><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect top 3 nimi, pikkus\nfrom laps\norder by vanus desc;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-41.png?w=218\" alt=\"\" class=\"wp-image-520\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect top 3 nimi, pikkus\nfrom laps\norder by vanus desc;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-42.png?w=134\" alt=\"\" class=\"wp-image-522\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><em>#10(moodle)<\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>3 \u0441\u0432\u043e\u0438\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1.<em>\u0437\u0430\u043f\u0440\u043e\u0441<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE laps\nSET vanus=17\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-43.png?w=399\" alt=\"\" class=\"wp-image-524\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-44.png?w=388\" alt=\"\" class=\"wp-image-525\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2.<em>\u0437\u0430\u043f\u0440\u043e\u0441<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE laps\nSET silmadeVarv=&#039;hall&#039;\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-45.png?w=376\" alt=\"\" class=\"wp-image-528\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.<em>\u0437\u0430\u043f\u0440\u043e\u0441<\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nUPDATE loom\nSET loomaNimi=&#039;koer&#039;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-46.png?w=201\" alt=\"\" class=\"wp-image-530\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>XAMPP<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-47.png?w=235\" alt=\"\" class=\"wp-image-532\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-48.png?w=852\" alt=\"\" class=\"wp-image-534\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt-49.png?w=561\" alt=\"\" class=\"wp-image-535\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u0412\u044b\u0431\u0440\u0430\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441 \u0438\u043c\u0435\u043d\u0435\u043c laps XAMPP Tabeli loom loomine XAMPP 1. Tingimused N\u00e4idata ainult nimi ja pikkus XAMPP N\u00e4idata ainult lapsed, kelle pikkus on suurem kui 175 XAMPP Sorteerimine XAMPP Naitame koik nimed mis algavad K XAMPP Naitame koik nimed mis sisaldavad \u2018e\u2019 XAMPP Vahemik \u2013 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u043a \u2013 betweenLeiama lapsed vanuses (5;15) [&hellip;]<\/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-2030","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SELECT sentences - Daria Halchenko I Portfoolio<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SELECT sentences - Daria Halchenko I Portfoolio\" \/>\n<meta property=\"og:description\" content=\"\u0412\u044b\u0431\u0440\u0430\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441 \u0438\u043c\u0435\u043d\u0435\u043c laps XAMPP Tabeli loom loomine XAMPP 1. Tingimused N\u00e4idata ainult nimi ja pikkus XAMPP N\u00e4idata ainult lapsed, kelle pikkus on suurem kui 175 XAMPP Sorteerimine XAMPP Naitame koik nimed mis algavad K XAMPP Naitame koik nimed mis sisaldavad \u2018e\u2019 XAMPP Vahemik \u2013 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u043a \u2013 betweenLeiama lapsed vanuses (5;15) [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/\" \/>\n<meta property=\"og:site_name\" content=\"Daria Halchenko I Portfoolio\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-25T08:03:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/\",\"url\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/\",\"name\":\"SELECT sentences - Daria Halchenko I Portfoolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kodu3.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/pilt.png?w=382\",\"datePublished\":\"2024-10-15T22:14:25+00:00\",\"dateModified\":\"2024-10-25T08:03:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kodu3.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/pilt.png?w=382\",\"contentUrl\":\"https:\\\/\\\/kodu3.wordpress.com\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/pilt.png?w=382\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/select-sentences\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SELECT sentences\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Daria Halchenko I Portfoolio\",\"description\":\"Noorem Tarkvaraarendaja eriala\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dariahalchenko23.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SELECT sentences - Daria Halchenko I Portfoolio","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/","og_locale":"en_US","og_type":"article","og_title":"SELECT sentences - Daria Halchenko I Portfoolio","og_description":"\u0412\u044b\u0431\u0440\u0430\u0442\u044c \u0432\u0441\u0435 \u043f\u043e\u043b\u044f \u0438\u0437 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0441 \u0438\u043c\u0435\u043d\u0435\u043c laps XAMPP Tabeli loom loomine XAMPP 1. Tingimused N\u00e4idata ainult nimi ja pikkus XAMPP N\u00e4idata ainult lapsed, kelle pikkus on suurem kui 175 XAMPP Sorteerimine XAMPP Naitame koik nimed mis algavad K XAMPP Naitame koik nimed mis sisaldavad \u2018e\u2019 XAMPP Vahemik \u2013 \u043f\u0440\u043e\u043c\u0435\u0436\u0443\u0442\u043e\u043a \u2013 betweenLeiama lapsed vanuses (5;15) [&hellip;]","og_url":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/","og_site_name":"Daria Halchenko I Portfoolio","article_modified_time":"2024-10-25T08:03:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/","url":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/","name":"SELECT sentences - Daria Halchenko I Portfoolio","isPartOf":{"@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/#primaryimage"},"image":{"@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/#primaryimage"},"thumbnailUrl":"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt.png?w=382","datePublished":"2024-10-15T22:14:25+00:00","dateModified":"2024-10-25T08:03:36+00:00","breadcrumb":{"@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/#primaryimage","url":"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt.png?w=382","contentUrl":"https:\/\/kodu3.wordpress.com\/wp-content\/uploads\/2024\/02\/pilt.png?w=382"},{"@type":"BreadcrumbList","@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/select-sentences\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SELECT sentences"}]},{"@type":"WebSite","@id":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/","name":"Daria Halchenko I Portfoolio","description":"Noorem Tarkvaraarendaja eriala","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/2030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=2030"}],"version-history":[{"count":1,"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/2030\/revisions"}],"predecessor-version":[{"id":2031,"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/2030\/revisions\/2031"}],"wp:attachment":[{"href":"https:\/\/dariahalchenko23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=2030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}