MySQL Forums
Forum List  »  Newbie

A divide-by-zero error was experienced.
Posted by: james bond
Date: August 30, 2022 05:01PM

I've only recently started using SQL so that this question may be ridiculous, but I'm at a loss.

I have a query that creates a column but returns a divide by zero error. Could someone please explain what's wrong with this query?

IncreaseAmount = CASE WHEN sp.AccessLevel = 1 THEN NULL ELSE CONVERT(decimal(12,2), ROUND((ps.PayRate - (ps.LastAnnualizedPayRate / ps.AnnualizingFactor)), 2)) TO ROUND((ps.PayRate - (ps.LastAnnualizedPayRate / ps.AnnualizingFactor

Please provide advice.

Options: ReplyQuote

Written By
A divide-by-zero error was experienced.
August 30, 2022 05:01PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.