PostgreSQLNumeric FunctionsDIV
SIGN

DIVNumeric Functions

GREATEST

Returns the integer quotient of y/x.

Syntax

DIV(y, x)

Example

Enter values below to update the example in real time.

total_qty
boxes_per_pallet
full_pallets
warehouse
SELECT total_qty, DIV(total_qty, boxes_per_pallet) AS full_pallets
FROM warehouse;