Query I tried: select cast(sum(Total) as int) from tbl_preorder where emailid='xyz@email.com'
SELECT SUM(CAST(Total AS INT)) FROM tbl_preorder WHERE emailid='xyz@email.com'
select sum(cast(Total) as int) from tbl_preorder where emailid='xyz@email.com'
select SUM(CAST(Total AS INT)) from tbl_preorder where emailid='xyz@email.com'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)