Bineesh Viswanath

Bineesh Viswanath

  • 1.3k
  • 428
  • 43.8k

Need help to get count of result in sql query

May 3 2022 1:09 PM

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)