SQL bulk collect and count
I have a database that has id's of people inside and money that they owe..
a person can be found in de database several times on diffrent rows.
I need to collect all people who have an amount open higher then 140 and
get all their information in the table (table name is money).
I tried using a select statement using having count(Cashdue) > 140 but he
won't allow that on a bulk collect.
Any idea how I can bulk collect information while at the same time
counting only the people who's total amount of money is above 140?
Thanks in advance.
No comments:
Post a Comment