2
Answers

Need help to get count of result in sql query

Dear All,

I need your help to get count of the row returned when run below query

select  count(*)   from balance group by status  having sum(curr+ thirty+sixty+ ninty)  >  0 and  sum(curr+ thirty + sixty+ ninty) < 100

the result getting is now like 1,1,1,1. but i need this result as 4

Answers (2)