Is there a way to get Sum of column whose datatype is varchar
Is there a way in SQL to get Sum of column whose datatype is varchar. I
tried with Cast method in SQL but it doesn't work. If any body has an idea
kindly share with me.
Query I tried:
select cast(sum(Total) as int) from tbl_preorder where
emailid='xyz@email.com'
No comments:
Post a Comment