SQL Sum is an inbuilt function in SQL Server. It returns the sum of a particular field/column in the rows matching criteria. Also, it can return the sum of all the fields of all rows in the table if you don’t specify any criteria. In this article, we will discuss the SQL Sum Function. Also,… Read more SQL Sum Function | Sum a Column of Rows Matching a Criteria

# Author: Vishesh Ahuja

## PHP cos Function | Find Cosine Value of a Number

Trigonometry is one of the most important concepts in Mathematics. PHP cos is an inbuilt Math Function in PHP. It calculates the cosine value of a number in radians. The cosine value oscillates between -1 and 1. In this article, we will discuss the PHP cos Function. Also, we will discuss an example of using… Read more PHP cos Function | Find Cosine Value of a Number

## PHP acos Function | Calculate Arc Cosine of a Number

Trigonometry is one of the most important concepts in Mathematics. PHP acos is an inbuilt Math Function in PHP. It calculates the arc cosine of a number in radians which works the opposite of PHP cos Function. In this article, we will discuss the PHP acos Function. Also, we will discuss an example of using… Read more PHP acos Function | Calculate Arc Cosine of a Number

## SQL sqrt Function | Square Root of a Number

SQL sqrt is an inbuilt Math Function in SQL Server. It calculates the square root of an input number in SQL Server. In this article, we will discuss the SQL sqrt Function. Also, we will discuss a few examples of using it. Syntax SQRT (number) Parameters The function expects only one input. The number for… Read more SQL sqrt Function | Square Root of a Number

## SQL SIGN Function | Return Sign of a Number

SQL SIGN is an inbuilt Math Function in SQL Server. It returns the sign of a number (1 if the number if positive, -1 for negative). In this article, we will discuss the SQL SIGN Function. Also, we will discuss a few examples of using it. Syntax SIGN (number) Parameters The function expects only one… Read more SQL SIGN Function | Return Sign of a Number

## PHP decbin Function | Convert Decimal To Binary String

PHP decbin is an inbuilt Math Function in PHP. It converts an input decimal integer into its corresponding binary representation string. You can convert a binary string to its corresponding decimal integer using PHP bindec Function. Syntax decbin ($integer) Parameters The function accepts only one parameter. The decimal value for which you want to find… Read more PHP decbin Function | Convert Decimal To Binary String

## PHP bindec Function | Convert a Binary to Decimal

PHP bindec is an inbuilt Math Function in PHP. It converts an input binary string into its corresponding decimal representation. In this article, we will discuss the PHP bindec Function. You can use the PHP decbin Function to convert a decimal integer to it’s corresponding binary string. Syntax bindec ($binaryString) Parameters The function accepts only… Read more PHP bindec Function | Convert a Binary to Decimal

## SQL abs Function | Absolute Value of an Integer

SQL abs is an inbuilt Math function in SQL Server. It returns the absolute (positive) value of a number. It is identical to modulus in mathematics. In this article, we will discuss the abs Function in SQL Server. Also, we will discuss examples of using it. Syntax ABS (number) Parameters The function expects only one… Read more SQL abs Function | Absolute Value of an Integer

## SQL UNION Operator | Combine Separate SQL Statements

The SQL UNION operator combines the result of two or more SQL SELECT queries and returns the combined result of the queries as a union. In this article, we will discuss the SQL Union Clause. Also, we will discuss a few examples of using it. Syntax SELECT column1, column2 … columnN FROM table1 UNION SELECT… Read more SQL UNION Operator | Combine Separate SQL Statements

## SQL RIGHT JOIN

SQL RIGHT JOIN statement returns all the records present in the right table and matched records from the left table. However, the result will contain null for the rows which are not present in the left table. In this article, we will discuss the SQL RIGHT JOIN Statement. Also, we will discuss a few examples… Read more SQL RIGHT JOIN