Success in comic sales is relative. For indie comics, selling a few thousand copies might be a great achievement. Major publishers might expect sales in the hundreds of thousands or even millions to consider a comic a huge success. It also depends on the production costs and profit margins.
It's hard to give an exact number. Success can vary depending on the genre, target audience, and marketing efforts. Generally, if a comic sells tens of thousands of copies, it could be seen as successful.