golden nugget online

Bineesh Viswanath

Bineesh Viswanath

  • 1.8k
  • 330
  • 27.7k

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)