You are viewing a single comment's thread. Return to all comments →
SELECT CAST(CEILING((Sub.ActualAVG - Sub.FalseAVG)) AS INT) AS DIFFERENCE FROM ( SELECT ROUND(AVG(CAST(SALARY AS FLOAT)), 2) AS ActualAVG , ROUND(AVG(CAST(REPLACE(SALARY, 0, '') AS FLOAT)), 2) AS FalseAVG FROM EMPLOYEES ) AS Sub
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 →
MS SQL