ocdc
asked on
SQL Question_New
INVENTORY.partid, INVENTORY.description, (INVENTORY.reorderpnt - INVENTORY.stockqty)
Display the part id and description for all parts where the stock quantity is less than the reorder point. I have this one working:
SELECT PartID
, Description
FROM INVENTORY
WHERE Stockqty <= Reorderpnt;
How can I modify the query above to get the below :
For each part where this is true also display the amount that the stock quantity is below the reorder point. Display the parts in descending order of the computed difference.
Display the part id and description for all parts where the stock quantity is less than the reorder point. I have this one working:
SELECT PartID
, Description
FROM INVENTORY
WHERE Stockqty <= Reorderpnt;
How can I modify the query above to get the below :
For each part where this is true also display the amount that the stock quantity is below the reorder point. Display the parts in descending order of the computed difference.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER