|
select lavozimi, sum(oyligi) as 'oylik narxlari' from ishchilar group by lavozimi
|
| bet | 6/6 | | Sana | 13.05.2024 | | Hajmi | 3,59 Mb. | | #228155 |
Bog'liq malumot.qayta1-6select lavozimi, sum(oyligi) as 'oylik narxlari' from ishchilar group by lavozimi;
Group by kalit so‘zi va Sum() funksiyasining qo‘llanilishi
2.maktab ishchilari oyligi guruhlanib eng ko‘p oylik oluvchi topilsin
Group by kalit so’zi va Max() funksiyasining qo’llanilishi
3.maktab ishchilari oyligi usish tartibi bo`yicha tartiblansin va usish tartibiga teskari tartibda tartiblansin.
Select* from ishchilar order by oyligi;
Order by kalit so’zining qo’llanilishi
oyligini usish tartibiga teskari tartibda tartiblash:
Select* from ishchilar order by oyligi Desc;
Order by kalit so’zining Desc bilan qo‘llanilishi
4. maktab ishchilari oladigan oylikning 6000000 dan kam oylik haqida ma`lumot berilsin:
Select *from ishchilar having oyligi<6000000;
Having kalit so’zining qo‘llanilishi
Between ,not,in kalit so’zlarining qo‘llanilishi
|
| |
