Power() funksiyasidan foydalanish.
SQRT() - Sonning kvadrat ildizini topish. So`rov: SELECT id, SQRT(id) FROM hodimlar; Natija:
Sqrt() funksiyasidan foydalanish.
SIN() - Ifoda sinusini hisoblash.
So`rov: SELECT id, SIN(id) FROM hodimlar; Natija:
Sin() funksiyasidan foydalanish.
LOG()- Sonnig natural logarifmni hisoblash.
So`rov: SELECT id, LOG(id) FROM hodimlar; Natija:
BETWEEN() - ko`rsatilgan oraliqdagi ma‘lumotlarni chiqarish. So`rov: SELECT * FROM hodimlar WHERE id BETWEEN 1 AND 3; Natija:
Between() funksiyasidan foydalanish.
MID()- ustundagi yozuvlarning bosh harfini shiqarish.
So`rov: SELECT MID(Fish,1,1) AS " bosh harflari", Fish FROM hodimlar; Natija:
Mid() funksiyasidan foydalanish.
Do'stlaringiz bilan baham: |