This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am calculating salary using below query
SELECT '29' as Total_Days,'28' as Present_Days,
(14000 / 29) AS Per_Day,
(14000 / 29) * 28 AS Total_Salary;
But Total_Salary should be 14000 because Total_Days 29 and Present_Day 29
Well, multiply by 29 rather than 28 then.
But keep in mind that when you divide two integers you get integer division. That is the result of 14000 / 29 is 482 sharp, not 482 comma something. To get a division which includes the remnant, you need to cast at least one of the operands to a data type that handles decimals, for instance decimal or float.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more