You are viewing a single comment's thread. Return to all comments →
Try using this, use decimal instead of float and it will be corrected
SELECT CEILING(AVG(SALARY - CAST(REPLACE(CAST(SALARY AS VARCHAR(10)), '0', '') AS DECIMAL(10,4)))) FROM EMPLOYEES
Seems like cookies are disabled on this browser, please enable them to open this website
The Blunder
You are viewing a single comment's thread. Return to all comments →
Try using this, use decimal instead of float and it will be corrected