9. LEFT(qator,miqdor)
– qatorning
chap tomonidan, ko’rsatilgan
miqdordagi
belgilarni qaytaradi.
So`rov: select left(mutaxasislik_fani,4)as anonymousm from student;
Natija:
10.8 – rasm. Left()
funksiyasining qo’llanishi
10. RIGHT(qator, miqdor)
- qatorning o’ng tomonidan, ko’rsatilgan miqdordagi
belgilarni qaytaradi;
So`rov: select right(otasining_ismi,4)as Mohirjon from student;
Natija:
10.9 – rasm. Right()
funksiyasining qo’llanishi
11.
UCASE
-tanlangan qatorning harflarini katta qilib chiqaradi:
So’rov:Select ucase (otasining_ismi) from student;
Natija:
10.10-rasm.Ucase
funksiyasining qo’llanishi
12.
REVERSE
-tanlangan ustun elementlarini teskari tartibda chiqarib beradi;
So’rov:select reverse(otasining_ismi) from student;
Natija: