Select fish, abs(stipendiyasi) from talaba5

argumentdan katta yoki teng eng yaqin butun son

Download 449,5 Kb.

1 2

Bog'liq
3.1.MB

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

Tasodifiy qiymatlar:

SELECT random();

SELECT random() * 10 + 1 AS taxminiy;

SELECT floor(random() * 10 + 1)::int;

Download 449,5 Kb.

Do'stlaringiz bilan baham: