Skip to content

Tag Archives: DBMS-SQL

VAR_POP() function in MySQL is used to calculate population standard variance of an expression. Syntax : VAR_POP(expr); Parameter : This method accepts only one parameter.… Read More
STDDEV_SAMP() function in MySQL is used to calculate sample standard deviation of an expression. Syntax : STDDEV_SAMP(expr); Parameter : This method accepts only one parameter.… Read More
Sometimes we need to calculate population Standard deviation of an expression in MySQL. STDDEV() function can be used for this purpose in MySQL. It returns… Read More
TIMESTAMPDIFF() : This function in MySQL is used to return a value after subtracting a DateTime expression from another. Syntax : TIMESTAMPDIFF(unit,expr1,expr2) Parameters :  It… Read More
POWER() function : This function in SQL Server is used to return a results after raising a specified exponent number to a specified base number.… Read More
RAND() function : This function in SQL Server is used to return a random decimal value and this value lies in the range greater than… Read More
ROUND() function : This function in SQL Server is used to round off a specified number to a specified decimal places. Features : This function… Read More
SIGN() function : This function in SQL Server is used to return the sign of the specified number. It returns 1 if the number is… Read More
SQRT() function : This function in SQL Server is used to return the square root of a specified positive number. For example, if the specified… Read More
SPACE() : This function in SQL Server helps to return a string that has a specified number of spaces. This function is also available in… Read More
CHAR() : This function helps to convert an int ASCII code to character value i.e if the user pass an integer as an argument, the… Read More
BIT_OR() function in MySQL is used to return the bitwise OR of all bits in a given expression. It first converts all decimal values into… Read More
This function in MySQL takes a dotted representation of an IPv4 or IPv6 address and returns a binary string that represents the numeric value of… Read More
CHARINDEX() : This function in SQL Server helps to return the position of a substring within a given string. The searching performed in this function… Read More
STR_TO_DATE() : This function in MySQL helps to convert string values to date or time or DateTime values. The function will return zero (0000-00-00) if… Read More

Start Your Coding Journey Now!