Select  ΚΩΔ_ΠΕΛΑΤΗ

From ΠΕΛΑΤΕΣ          

Group by ΚΩΔ_ΠΕΛΑΤΗ

Having count(*) >1000