{"id":386,"date":"2024-02-15T09:22:23","date_gmt":"2024-02-15T07:22:23","guid":{"rendered":"https:\/\/vladislavkudr.wordpress.com\/?page_id=386"},"modified":"2024-02-15T09:22:23","modified_gmt":"2024-02-15T07:22:23","slug":"select-laused","status":"publish","type":"page","link":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/select-laused\/","title":{"rendered":"SELECT laused"},"content":{"rendered":"
\nSelect * from laps\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
    \n
  1. Tingimused<\/li>\n<\/ol>\n\n\n
    \nselect nimi, pikkus from laps\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi, pikku\nfrom laps\nWHERE pikkus >=175\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi, pikkus\nfrom laps\nWHERE pikkus >=175\nORDER by pikkus DESC;\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi\nFROM laps\nWHERE nimi like 'K%'\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi\nFROM laps\nWHERE nimi like '%e%'\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi, vanus\nFROM laps\nWHERE vanus between 5 and 10;\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n\n
    2. Agregaatfunktsioonid<\/p>\n\n\n\n
    SUM()<\/p>\n\n\n\n
    MIN()<\/p>\n\n\n\n
    MAX()<\/p>\n\n\n\n
    AVG() – keskmine<\/p>\n\n\n\n
    COUNT() – \u043a\u043e\u043b \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u043d\u044b\u0445 \u044f\u0447\u0435\u0435\u043a<\/p>\n\n\n
    \nSELECT AVG(pikkus) AS keskmine_pikkus\nFROM laps\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT SUM(vanus) AS summarne_vanus\nFROM laps\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT MIN(pikkus) AS minimaalne_pikkus, MAX(pikkus) AS maksimaalne_pikkus\nfrom laps\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect COUNT(*) as lasteArv\nfrom laps\nwhere synniLinn like 'Tallinn'\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nselect nimi,vanus\nfrom laps\norder by vanus DESC;\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT * FROM laps, loom\nWHERE laps.lapsID=loom.lapsID\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT * FROM laps INNER JOIN loom\nON laps.lapsID=loom.lapsID\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT laps.nimi, loom.loomaNimi\nFROM laps INNER JOIN loom\nON laps.lapsID=loom.lapsID\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT l.nimi, m.loomaNimi\nFROM laps l INNER JOIN loom m\nON l.lapsID=m.lapsID\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n
    \nSELECT l.nimi, m.loomaNimi\nFROM laps l INNER JOIN loom m\nON l.lapsID=m.lapsID\nWHERE m.loomaNimi like '%kass%';\n<\/pre><\/div>\n\n\n
    \"\"<\/figure>\n\n\n\n
    XAMPP<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi, pikkus from laps;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi, pikkus
    from laps
    WHERE pikkus >=175<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi, pikkus
    from laps
    WHERE pikkus >=175
    ORDER by pikkus DESC;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi
    FROM laps
    WHERE nimi like ‘K%’<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi
    FROM laps
    WHERE nimi like ‘%e%’<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi, vanus
    FROM laps
    WHERE vanus between 5 and 10;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT AVG(pikkus) AS keskmine_pikkus
    FROM laps<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT SUM(vanus) AS summarne_vanus
    FROM laps<\/p>\n\n\n\n
    ???<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT MIN(pikkus) AS minimaalne_pikkus, MAX(pikkus) AS maksimaalne_pikkus
    from laps<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select COUNT(*) as lasteArv
    from laps
    where synniLinn like ‘Tallinn’<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi,vanus
    from laps
    order by vanus DESC;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT * FROM laps, loom
    WHERE laps.lapsID=loom.lapsID<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT * FROM laps INNER JOIN loom
    ON laps.lapsID=loom.lapsID<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT laps.nimi, loom.loomaNimi
    FROM laps INNER JOIN loom
    ON laps.lapsID=loom.lapsID<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT l.nimi, m.loomaNimi
    FROM laps l INNER JOIN loom m
    ON l.lapsID=m.lapsID<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    SELECT l.nimi, m.loomaNimi
    FROM laps l INNER JOIN loom m
    ON l.lapsID=m.lapsID
    WHERE m.loomaNimi like ‘%kass%’;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    UPDATE laps
    SET pikkus=pikkus*1.1<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    <\/p>\n\n\n\n
    UPDATE laps
    SET synnilinn=’Tallinn’<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    UPDATE laps
    SET vanus=17,silmadeVarv=’Sinine’,pikkus=175<\/p>\n\n\n\n
    SELECT * FROM laps<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select top 3 nimi,pikkus
    from laps
    order by pikkus DESC;<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    select nimi,pikkus
    from laps
    order by pikkus DESC limit 3;<\/p>\n\n\n\n
    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
    2. Agregaatfunktsioonid SUM() MIN() MAX() AVG() – keskmine COUNT() – \u043a\u043e\u043b \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u043d\u044b\u0445 \u044f\u0447\u0435\u0435\u043a XAMPP select nimi, pikkus from laps; select nimi, pikkusfrom lapsWHERE pikkus >=175 select nimi, pikkusfrom lapsWHERE pikkus >=175ORDER by pikkus DESC; select nimiFROM lapsWHERE nimi like ‘K%’ select nimiFROM lapsWHERE nimi like ‘%e%’ select nimi, vanusFROM lapsWHERE vanus between 5 and 10; […]<\/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-386","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/comments?post=386"}],"version-history":[{"count":0,"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/pages\/386\/revisions"}],"wp:attachment":[{"href":"https:\/\/vladislavkudriashev23.thkit.ee\/WP\/wp-json\/wp\/v2\/media?parent=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}