select cid,RecommendToFriend from companyreviews where isrss=0 and cid=98 result is cid RecommendToFriend 98 1 98 1 98 0 98 0 98 1 I want the percentage of Recommendtofriend field. I have to write like this
select ( sum(RecommendToFriend) /(select Count(RecommendToFriend) from CompanyReviews where IsRss=0 and cid=98))* 100 from companyreviews where IsRss=0 and cid=98
select sum(RecommendToFriend)*100.0/count(RecommendToFriend) from CompanyReviews where IsRss=0 and cid=98
SELECT cast(SUM(RecommendToFriend) AS decimal(10,2)) / COUNT(RecommendToFriend)*100 FROM companyreviews
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)