Timur Baširov Portfoolio

выбрать все поля из таблицы с именем laps

select * from laps

 выбрать из таблицы table_name все поля

1. Tingimused
   Näidata ainult nimi ja pikkus
   

select nimi,pikkus from laps

select nimi,pikkus
from laps 
where pikkus>=150;

select nimi,pikkus
from laps
where pikkus >=150
order by pikkus desc;

select nimi
from laps
where nimi like 'M%';

select nimi
from laps
where nimi like '%E%';

select nimi, vanus
from laps
where vanus between 5 and 16;

or

select nimi, vanus
from laps
where vanus >= 5 and vanus <=16;

2. Agregaatfunktsioonid

SUM()
MIN()
MAX()
AVG()
COUNT()

select AVG(pikkus) AS keskmine_pikkus
from laps

select sum(vanus) as sum_vanus
from laps

select min(vanus) as min_vanus,max(vanus) as max_vanus
from laps

select count(*) as lastearv
from laps
where synnilinn like 'Tallinn'

select nimi, vanus
from laps
order by vanus DESC;

select * from laps, loom
where laps.lapsID=loom.lapsID

or

Select * from laps inner join loom
on laps.lapsID=loom.lapsID;

Select * from laps inner join loom
on laps.lapsID=loom.lapsID;

select lo.loomaNimi, l.nimi
from laps l inner join loom lo
on l.lapsID=lo.lapsID;

select lo.loomaNimi, l.nimi
from laps l inner join loom lo
on l.lapsID=lo.lapsID
where lo.loomaNimi like '%kass%';

UPDATE laps
SET pikkus=pikkus*1.1 

увеличиваем рост всех детей на 10%

UPDATE laps
SET synnilinn='Tallinn'

изменяем столбец synnilinn и установить значение Tallinn

UPDATE laps
set vanus=24,pikkus=158;

select nimi
from laps
where vanus=24 and pikkus <150

select top 3 nimi, pikkus
from laps
order by pikkus desc

SQL и XXAMP

select nimi,pikkus 
from laps 
order by pikkus desc
limit 3;