Radiandan gradusga o’tkazish
Bir ustun qiymatini ikkinchi ustun qiymatiga bo’lgandagi butun son
select fish, div(stipendiyasi,id) from talaba5
Shunga o’xshash bir nechta funksiyalar mavjud:
Funktsiya
|
Tavsif
|
Misol
|
Natija
|
abs(x)
|
mutlaq qiymat
|
abs(-17,4)
|
17.4
|
cbrt(dp)
|
kub ildizi
|
cbrt (27.0)
|
3
|
ceil(dp or numeric)
|
argumentdan katta yoki teng eng yaqin butun son
|
yuqori (-42,8)
|
-42
|
ceiling(dp or numeric)
|
argumentdan katta yoki teng eng yaqin butun son (bir xil ceil)
|
shift (-95,3)
|
-95
|
degrees(dp)
|
Radiandan gradusga
|
daraja (0,5)
|
28.6478897565412
|
div(y numeric, x numeric)
|
y / x ning butun soni
|
div(9,4)
|
2
|
exp(dp or numeric)
|
eksponenta
|
exp (1,0)
|
2.71828182845905
|
factorial(bigint)
|
faktorial
|
faktoriy(5)
|
120
|
floor(dp or numeric)
|
argumentdan kichik yoki teng eng yaqin butun son
|
qavat(-42,8)
|
-43
|
ln(dp or numeric)
|
tnatural logarifm
|
ln (2,0)
|
0,693147180559945
|
log(dp or numeric)
|
10 asosli logarifm
|
log(100.0)
|
2
|
log(b numeric, x numeric)
|
b asosga ko’ra,x logarifm
|
log(2.0, 64.0)
|
6.0000000000
|
mod(y, x)
|
y / x ning qolgan qismi
|
mod(9,4)
|
1
|
pi()
|
"p" doimiysi
|
pi()
|
3.14159265358979
|
power(a dp, b dp)
|
A ning b darajasi
|
quvvat (9,0, 3,0)
|
729
|
power(a numeric, b numeric)
|
A ning b darajasi
|
quvvat (9,0, 3,0)
|
729
|
radians(dp)
|
darajadan radianga
|
radian (45,0)
|
0,785398163397448
|
round(dp or numeric)
|
eng yaqin butun songa yaxlitlash
|
round (42,4)
|
42
|
round(v numeric, s int)
|
o'nli kasrgacha yaxlitlash
|
round(42.4382, 2)
|
42.44
|
scale(numeric)
|
argument shkalasi (kasr qismidagi o'nlik raqamlar soni)
|
masshtab(8.41)
|
2
|
sqrt(dp or numeric)
|
kvadrat ildiz
|
sqrt(2,0)
|
1.4142135623731
|
trunc(dp or numeric)
|
nolga qarab qisqartiring
|
tranc (42,8)
|
42
|
trunc(v numeric, s int)
|
s kasrga qisqartiring
|
trunc(42.4382, 2)
|
42.43
|
Triganametrik funksiyalar
Funktsiya (radianlar)
|
Funktsiya (daraja)
|
Tavsif
|
acos(x)
|
acosd(x)
|
teskari kosinus
|
asin(x)
|
asind(x)
|
teskari sinus
|
atan(x)
|
atand(x)
|
teskari tangens
|
atan2(y, x)
|
atan2d(y, x)
|
y / x ning teskari tangensi
|
cos(x)
|
cosd(x)
|
kosinus
|
cot(x)
|
cotd(x)
|
kotangent
|
sin(x)
|
sind(x)
|
sinus
|
tan(x)
|
tand(x)
|
tangens
|
Tasodifiy qiymatlar:
SELECT random();
SELECT random() * 10 + 1 AS taxminiy;
SELECT floor(random() * 10 + 1)::int;
Dostları ilə paylaş: |