/ (Division) (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
Divides one number by another (an arithmetic division operator).
Transact-SQL syntax conventions
Syntax
dividend / divisor
Note
To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.
Arguments
dividend
Is the numeric expression to divide. dividend can be any valid expression of any one of the data types of the numeric data type category, except the datetime and smalldatetime data types.
divisor
Is the numeric expression by which to divide the dividend. divisor can be any valid expression of any one of the data types of the numeric data type category, except the datetime and smalldatetime data types.
Result Types
Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).
If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional part of the result truncated.
Remarks
The actual value returned by the / operator is the quotient of the first expression divided by the second expression.
Examples
The following example uses the division arithmetic operator to calculate the sales target per month for the sales people at Adventure Works Cycles.
-- Uses AdventureWorks
SELECT s.BusinessEntityID AS SalesPersonID, FirstName, LastName, SalesQuota, SalesQuota/12 AS 'Sales Target Per Month'
FROM Sales.SalesPerson AS s
JOIN HumanResources.Employee AS e
ON s.BusinessEntityID = e.BusinessEntityID
JOIN Person.Person AS p
ON e.BusinessEntityID = p.BusinessEntityID;
Here is a partial result set.
SalesPersonID FirstName LastName SalesQuota Sales Target Per Month
------------- ------------ ----------------- ----------- ------------------
274 Stephen Jiang NULL NULL
275 Michael Blythe 300000.00 25000.00
276 Linda Mitchell 250000.00 20833.3333
277 Jillian Carson 250000.00 20833.3333
Examples: Azure Synapse Analytics and Analytics Platform System (PDW)
The following example uses the division arithmetic operator to calculate a simple ratio of each employees' vacation hours to sick hours.
-- Uses AdventureWorks
SELECT FirstName, LastName, VacationHours/SickLeaveHours AS PersonalTimeRatio
FROM DimEmployee;
See Also
Data Types (Transact-SQL)
Built-in Functions (Transact-SQL)
Operators (Transact-SQL)
SELECT (Transact-SQL)
WHERE (Transact-SQL)
/= (Division Assignment) (Transact-SQL)
Compound Operators (Transact-SQL)