4. 1-Misol Xodimlar jadvalning ikkita ustunini birlashtirgan holda natija olish

4.1-Misol Xodimlar jadvalning ikkita ustunini birlashtirgan holda natija olish.
SELECT concat(fish , " ",yosh ) FROM `arizachi` WHERE yosh>20

4.2-misol. SELECT concat("lavozimi ", lavozimi," olganmi ", olganligi) AS collect FROM `buxgalteriya`

4.3-misol. SELECT concat(manzil," ",idbuyurtma) AS tayyor FROM `buyurtma`

4.4-misol.Matematik hisob kitoblarni bajarish.
SELECT concat(manzil," ",pochta ) AS pochta_manzil FROM `buyurtmachi`;

SELECT fish,concat("ismi ",fish," telefon raqami ", telraqami) AS full FROM `qabulqiluvchi`

SELECT concat(idremont," xarajat=",xarajat) AS xarajat FROM `remont` WHERE xarajat>100

SELECT idxodim,concat("ism sharifi ",fish," telefoni ",telraqami," lavozimi ",lavozimi) AS information FROM `xodimlar`;