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, you can't reply to this topic. It has been closed.

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.