{"id":378,"date":"2024-02-15T10:11:38","date_gmt":"2024-02-15T08:11:38","guid":{"rendered":"https:\/\/davidlennuk.wordpress.com\/?page_id=378"},"modified":"2024-10-25T08:11:19","modified_gmt":"2024-10-25T08:11:19","slug":"select-laused","status":"publish","type":"page","link":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/","title":{"rendered":"SELECT statements"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>select * from laps<\/code><\/pre>\n\n\n\n<p> Tingimused <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-27.png?w=337\" alt=\"\" class=\"wp-image-401\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-36.png?w=616\" alt=\"\" class=\"wp-image-417\" style=\"width:344px;height:auto\" \/><\/figure>\n\n\n\n<p>N\u00e4idata ainult nimi ja pikkus<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Select * from loom;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-30.png?w=178\" alt=\"\" class=\"wp-image-407\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-37.png?w=330\" alt=\"\" class=\"wp-image-419\" style=\"width:168px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi, pikkus from <\/code><\/pre>\n\n\n\n<p>&#8211;n\u00e4idata nimi ja pikkus<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-29.png?w=136\" alt=\"\" class=\"wp-image-404\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi, pikkus<br>from laps<br>Where pikkus &gt;=150;<\/code><\/pre>\n\n\n\n<p>&#8211;n\u00e4itame lapsed kes on pikem kui 150<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-17.png?w=126\" alt=\"\" class=\"wp-image-383\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-38.png?w=177\" alt=\"\" class=\"wp-image-421\" style=\"width:108px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi, pikkus<br>from laps<br>Where pikkus &gt;=150<br>Order by pikkus DESC;<\/code><\/pre>\n\n\n\n<p>&#8211;lisade juurde andmete sorterimine<br>&#8211;DESC &#8211; suuremast v\u00e4ikseni<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-18.png?w=128\" alt=\"\" class=\"wp-image-385\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-39.png?w=224\" alt=\"\" class=\"wp-image-422\" style=\"width:152px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi<br>FROM laps<br>where nimi like 'M%'<\/code><\/pre>\n\n\n\n<p>&#8211;n\u00e4itame k\u00f5ik nimed mis algavad P<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-19.png?w=82\" alt=\"\" class=\"wp-image-387\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-40.png?w=96\" alt=\"\" class=\"wp-image-424\" style=\"width:78px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi<br>from laps<br>where nimi like 'e%';<\/code><\/pre>\n\n\n\n<p>&#8211;n\u00e4itame k\u00f5ik nimed mis siseldavad &#8216;e&#8217;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-20.png?w=67\" alt=\"\" class=\"wp-image-389\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-41.png?w=97\" alt=\"\" class=\"wp-image-425\" style=\"width:73px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select nimi, vanus<br>from laps<br>where vanus &gt;=5 and vanus &lt;=10;<\/code><\/pre>\n\n\n\n<p>&#8211;vahemik &#8211; between<br>&#8211;leiame lapsed vanused vanuses (5;10)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-21.png?w=111\" alt=\"\" class=\"wp-image-390\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-42.png?w=165\" alt=\"\" class=\"wp-image-427\" style=\"width:93px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select AVG(pikkus) AS keskmine_pikkus<br>from laps;<\/code><\/pre>\n\n\n\n<p>&#8211;leia keskmine pikkus<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-22.png?w=122\" alt=\"\" class=\"wp-image-392\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-43.png?w=209\" alt=\"\" class=\"wp-image-428\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select SUM(pikkus) AS summaarne_vanus<br>from laps;<\/code><\/pre>\n\n\n\n<p>&#8211;leia summarne vanus<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-23.png?w=149\" alt=\"\" class=\"wp-image-394\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-44.png?w=225\" alt=\"\" class=\"wp-image-430\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select min(pikkus) AS min_Pikkus, max(pikkus) as max_pikkus<br>from laps;<\/code><\/pre>\n\n\n\n<p>&#8211;leia suurem pikkus ja v\u00e4iksem pikkus<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-24.png?w=183\" alt=\"\" class=\"wp-image-395\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-45.png?w=294\" alt=\"\" class=\"wp-image-431\" style=\"width:197px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>select count(*) as lasteArv<br>from laps<br>where synnilinn like 'Tartu'<\/code><\/pre>\n\n\n\n<p>&#8211;otsida laste arv, kellel synniLinn on Tartu<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-25.png?w=104\" alt=\"\" class=\"wp-image-397\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-46.png?w=111\" alt=\"\" class=\"wp-image-433\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select top 1 nimi, vanus<br>from laps<br>order by vanus Desc;<\/code><\/pre>\n\n\n\n<p>&#8211;Otsida suurima vanuse tebelist lapsenimi<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-26.png?w=121\" alt=\"\" class=\"wp-image-399\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select * from laps, loom<br>Where laps.lapsID=loom.lapsID<\/code><\/pre>\n\n\n\n<p>&#8211;select laused kahe tabelite p\u00f5hjal<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-31.png?w=513\" alt=\"\" class=\"wp-image-409\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-47.png?w=949\" alt=\"\" class=\"wp-image-434\" style=\"width:504px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select * from laps INNER JOIN loom<br>ON laps.lapsID=loom.lapsID<\/code><\/pre>\n\n\n\n<p>&#8211;INNER JOIN &#8211; vnutrennee soedinenie<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-32.png?w=524\" alt=\"\" class=\"wp-image-410\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-48.png?w=944\" alt=\"\" class=\"wp-image-436\" style=\"width:514px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select loom.loomaNimi, laps.nimi<br>from laps INNER JOIN loom<br>ON laps.lapsID=loom.lapsID;<\/code><\/pre>\n\n\n\n<p>&#8211;ainult vajalikud veerud<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-33.png?w=146\" alt=\"\" class=\"wp-image-412\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-49.png?w=221\" alt=\"\" class=\"wp-image-437\" style=\"width:158px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select lo.loomaNimi, l.nimi<br>from laps l INNER JOIN loom lo<br>ON l.lapsID=l.lapsID;<\/code><\/pre>\n\n\n\n<p>&#8211;kasutame pseudon\u00fc\u00fcmid<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-34.png?w=147\" alt=\"\" class=\"wp-image-413\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-50.png?w=194\" alt=\"\" class=\"wp-image-439\" style=\"width:94px;height:auto\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-code\"><code>Select lo.loomaNimi, l.nimi<br>from laps l INNER JOIN loom lo<br>on l.lapsID=lo.lapsID<br>Where lo.loomaNimi like '%kass%';<\/code><\/pre>\n\n\n\n<p>&#8211;tahaks teada kasside omanikud(lapsenimed)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-35.png?w=142\" alt=\"\" class=\"wp-image-415\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-51.png?w=211\" alt=\"\" class=\"wp-image-440\" style=\"width:185px;height:auto\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u2014 6 \u00fclesanne \u0418\u0437\u043c\u0435\u043d\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0438\u0441\u0435\u0439<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE laps<br>SET pikkus=pikkus*1.1 \u2013 \u0443\u0432\u0435\u043b\u0438\u0447\u0438\u0432\u0430\u0435\u043c \u0440\u043e\u0441\u0442 \u0432\u0441\u0435\u0445 \u0434\u0435\u0442\u0435\u0439 \u043d\u0430 10%<\/code><\/pre>\n\n\n\n<p>\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<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE laps<br>SET synnilinn=\u2019Tallinn\u2019<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-52.png?w=332\" alt=\"\" class=\"wp-image-443\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-53.png?w=593\" alt=\"\" class=\"wp-image-444\" style=\"width:354px;height:auto\" \/><\/figure>\n\n\n\n<p>7 \u00fclesanne \u041e\u0431\u043d\u043e\u0432\u0438\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u0443 laps \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c \u0432\u0441\u0435\u043c \u0434\u0435\u0442\u044f\u043c 2000\u0433\u043e\u0434\u0430 \u0440\u043e\u0436\u0434\u0435\u043d\u0438\u044f \u0440\u043e\u0441\u0442 158.<\/p>\n\n\n\n<p id=\"yui_3_17_2_1_1707987595390_34\">UPDATE \u2026.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nUPDATE lapsSET pikkus = 158WHERE vanus = 2000;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-54.png?w=490\" alt=\"\" class=\"wp-image-447\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>8. \u041a\u043e\u043c\u0431\u0438\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0439. \u0412\u044b\u0432\u0435\u0441\u0442\u0438 \u0432\u0441\u0435 \u0438\u043c\u0435\u043d\u0430 \u0434\u0435\u0442\u0435\u0439, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0440\u043e\u0434\u0438\u043b\u0438\u0441\u044c \u0432 2000 \u0433\u043e\u0434\u0443 \u0438 \u0438\u043c\u0435\u044e\u0442 \u0440\u043e\u0441\u0442 \u043c\u0435\u043d\u044c\u0448\u0435 150\u0441\u043c.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>update laps<br>set pikkus = 120<br>where vanus =14;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-55.png?w=316\" alt=\"\" class=\"wp-image-449\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-57.png?w=609\" alt=\"\" class=\"wp-image-452\" style=\"width:332px;height:auto\" \/><\/figure>\n\n\n\n<p>9. 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.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT TOP 3 nimi, pikkusFROM lapsORDER BY pikkus DESC;\n<\/pre><\/div>\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>2 Agregaatffunktioonid<\/p>\n\n\n\n<p>SUM()<\/p>\n\n\n\n<p>MIN()<\/p>\n\n\n\n<p>MAX()<\/p>\n\n\n\n<p>AVG()<\/p>\n\n\n\n<p>COUNT()<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tingimused N\u00e4idata ainult nimi ja pikkus &#8211;n\u00e4idata nimi ja pikkus &#8211;n\u00e4itame lapsed kes on pikem kui 150 &#8211;lisade juurde andmete sorterimine&#8211;DESC &#8211; suuremast v\u00e4ikseni &#8211;n\u00e4itame k\u00f5ik nimed mis algavad P &#8211;n\u00e4itame k\u00f5ik nimed mis siseldavad &#8216;e&#8217; &#8211;vahemik &#8211; between&#8211;leiame lapsed vanused vanuses (5;10) &#8211;leia keskmine pikkus &#8211;leia summarne vanus &#8211;leia suurem pikkus ja v\u00e4iksem pikkus&hellip; <a class=\"more-link\" href=\"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/\">Continue reading <span class=\"screen-reader-text\">SELECT statements<\/span><\/a><\/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-378","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SELECT statements - David Lennuk portfoolio || eng<\/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:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SELECT statements - David Lennuk portfoolio || eng\" \/>\n<meta property=\"og:description\" content=\"Tingimused N\u00e4idata ainult nimi ja pikkus &#8211;n\u00e4idata nimi ja pikkus &#8211;n\u00e4itame lapsed kes on pikem kui 150 &#8211;lisade juurde andmete sorterimine&#8211;DESC &#8211; suuremast v\u00e4ikseni &#8211;n\u00e4itame k\u00f5ik nimed mis algavad P &#8211;n\u00e4itame k\u00f5ik nimed mis siseldavad &#8216;e&#8217; &#8211;vahemik &#8211; between&#8211;leiame lapsed vanused vanuses (5;10) &#8211;leia keskmine pikkus &#8211;leia summarne vanus &#8211;leia suurem pikkus ja v\u00e4iksem pikkus&hellip; Continue reading SELECT statements\" \/>\n<meta property=\"og:url\" content=\"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/\" \/>\n<meta property=\"og:site_name\" content=\"David Lennuk portfoolio || eng\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-25T08:11:19+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=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/\",\"name\":\"SELECT statements - David Lennuk portfoolio || eng\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/image-27.png?w=337\",\"datePublished\":\"2024-02-15T08:11:38+00:00\",\"dateModified\":\"2024-10-25T08:11:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/#primaryimage\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/image-27.png?w=337\",\"contentUrl\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/image-27.png?w=337\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/select-laused\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SELECT statements\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/davidlennuk23.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"David Lennuk portfoolio || eng\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/davidlennuk23.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 statements - David Lennuk portfoolio || eng","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:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/","og_locale":"en_US","og_type":"article","og_title":"SELECT statements - David Lennuk portfoolio || eng","og_description":"Tingimused N\u00e4idata ainult nimi ja pikkus &#8211;n\u00e4idata nimi ja pikkus &#8211;n\u00e4itame lapsed kes on pikem kui 150 &#8211;lisade juurde andmete sorterimine&#8211;DESC &#8211; suuremast v\u00e4ikseni &#8211;n\u00e4itame k\u00f5ik nimed mis algavad P &#8211;n\u00e4itame k\u00f5ik nimed mis siseldavad &#8216;e&#8217; &#8211;vahemik &#8211; between&#8211;leiame lapsed vanused vanuses (5;10) &#8211;leia keskmine pikkus &#8211;leia summarne vanus &#8211;leia suurem pikkus ja v\u00e4iksem pikkus&hellip; Continue reading SELECT statements","og_url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/","og_site_name":"David Lennuk portfoolio || eng","article_modified_time":"2024-10-25T08:11:19+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/","name":"SELECT statements - David Lennuk portfoolio || eng","isPartOf":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/#primaryimage"},"image":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/#primaryimage"},"thumbnailUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-27.png?w=337","datePublished":"2024-02-15T08:11:38+00:00","dateModified":"2024-10-25T08:11:19+00:00","breadcrumb":{"@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/#primaryimage","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-27.png?w=337","contentUrl":"https:\/\/davidlennuk23.thkit.ee\/wp\/wp-content\/uploads\/2024\/02\/image-27.png?w=337"},{"@type":"BreadcrumbList","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/select-laused\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SELECT statements"}]},{"@type":"WebSite","@id":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/#website","url":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/","name":"David Lennuk portfoolio || eng","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/davidlennuk23.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:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/378","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=378"}],"version-history":[{"count":1,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/378\/revisions"}],"predecessor-version":[{"id":1278,"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/378\/revisions\/1278"}],"wp:attachment":[{"href":"https:\/\/davidlennuk23.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}