CONCAT() function in MySQL is used to concatenating the given arguments. It may have one or more arguments. If all arguments are nonbinary strings, the… Read More
Tag Archives: DBMS-SQL
SOUNDEX() function in MySQL is used to return a phonetic representation of a string. The phonetic represents the way the string will sound. The SOUNDEX… Read More
RTRIM() : It is the function in MySQL that is used to remove trailing spaces from a string. Syntax : RTRIM(str) Parameter : RTRIM() function… Read More
1. FormatCurrency() Function : FormatCurrency() Function in MS Access is used to Returns an expression formatted as a currency value using the currency symbol defined in… Read More
IRR() Function in MS Access is used to return a Double value specifying the internal rate of return for a series of periodic cash flows,… Read More
The MOD() function in MySQL is used to find the remainder of one number divided by another. The MOD() function returns the remainder of dividend… Read More
GREATEST() function in MySQL is used to find greatest values from given arguments respectively. If any given value is NULL, it returns NULLs. Otherwise, it… Read More
The ROUND() function in MySQL is used to round a number to a specified number of decimal places. If no specified number of decimal places… Read More
To reverse any statement Word by Word in SQL server we could use the SUBSTRING function which allows us to extract and display the part… Read More
In this article, we are going to cover the LOG2() function that means it will calculate the logarithm of a specific number with base 2.… Read More
In this article, you will see how the TRUNCATE() function works. The TRUNCATE function in MySQL is used to truncate a number to a specified… Read More
1. TAN() Function : The TAN() function returns the tangent of a number. Syntax : TAN(number) Parameter : Required. A numeric value. number : It… Read More
In this article, we are going to cover DateDiff() and DatePart function with examples. DateDiff() is used to calculate the difference between two dates. DatePart… Read More
POWER() function in MySQL is used to find the value of a number raised to the power of another number. It Returns the value of… Read More
DEGREES() function in MySQL is used to convert the radian values into degrees. The formula for converting radian to degree is : π radian =… Read More
Courses
