Export (0) Print
Expand All


Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.

QUOTIENT(<numerator>, <denominator>)




The dividend, or number to divide.


The divisor, or number to divide by.

A whole number.

If either argument is non-numeric, QUOTIENT returns the #VALUE! error value.

You can use a column reference instead of a literal value for either argument. However, if the column that you reference contains a 0 (zero), an error is returned for the entire column of values.

The following formulas return the same result, 2.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft