Loading

Need help to get count of result in sql query

Bineesh Viswanath

4y868SQL

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bineesh Viswanath4y ago
hi Sachin,

when execute below query , getting error - aggregate function nested

select Sum(count(*)) Over() from balance having sum(curr+ thirty+sixty+ ninty) > 0 and sum(curr+ thirty+sixty+ ninty) < 100
+1
Sachin Singh4y ago
1. select Sum(count(*)) Over() from balance group by status having sum(curr+ thirty+sixty+ ninty) > 0 and sum(curr+ thirty + sixty+ ninty) < 100
+1