FIELD() : This function helps in returning the position of a value in the given value list. If the user passes string values as the… Read More
Tag Archives: DBMS-SQL
EXPORT_SET() : This function helps to return a string which will show the bits in number. The function requires 5 arguments for its functioning. The… Read More
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
