how i convert varchar sal field to numeric in query
select sum(sal) from emp1
error:the sum or average aggregate operation cannot take a varchar data type as an argument.
Use Cast as in:
select sum(cast(sal as float)) from emp1
how i convert varchar sal field to numeric in query
select sum(sal) from emp1
error:the sum or average aggregate operation cannot take a varchar data type as an argument.
Use Cast as in:
select sum(cast(sal as float)) from emp1
No comments:
Post a Comment