subtract the greatest from smallest in sql

Created Sep 20, 2022 Edited Sep 20, 2022

Viewed 19

need equivalent query in sql for below requirement as greatest function is not available in sql. GREATEST(SHIP_QTY - RETURN_QTY, 0)

sql-server sql