SQL Matematik Fonksiyonları

ABSReturns the absolute value of a number
ACOSReturns the arc cosine of a number
ASINReturns the arc sine of a number
ATANReturns the arc tangent of a number
ATN2Returns the arc tangent of two numbers
AVGReturns the average value of an expression
CEILINGReturns the smallest integer value that is >= a number
COUNTReturns the number of records returned by a select query
COSReturns the cosine of a number
COTReturns the cotangent of a number
DEGREESConverts a value in radians to degrees
EXPReturns e raised to the power of a specified number
FLOORReturns the largest integer value that is <= to a number
LOGReturns the natural logarithm of a number, or the logarithm of a number to a specified base
LOG10Returns the natural logarithm of a number to base 10
MAXReturns the maximum value in a set of values
MINReturns the minimum value in a set of values
PIReturns the value of PI
POWERReturns the value of a number raised to the power of another number
RADIANSConverts a degree value into radians
RANDReturns a random number
ROUNDRounds a number to a specified number of decimal places
SIGNReturns the sign of a number
SINReturns the sine of a number
SQRTReturns the square root of a number
SQUAREReturns the square of a number
SUMCalculates the sum of a set of values
TANReturns the tangent of a number

ref: https://www.w3schools.com/sql/sql_ref_sqlserver.asp

Yazı oluşturuldu 38

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

Benzer yazılar

Aramak istediğinizi üstte yazmaya başlayın ve aramak için enter tuşuna basın. İptal için ESC tuşuna basın.

Üste dön