You are viewing a single comment's thread. Return to all comments →
you can use it with a cast (float to int). here is my code.
select cast(ceiling(avg(cast(salary as float))-avg(convert(float, replace(str(salary), '0', '')))) as int) 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 →
you can use it with a cast (float to int). here is my code.
sql