SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete statement based on select count

Eslam_ElbyalySep 1 2016 — edited Sep 1 2016

hi ,

i have this select statement

SELECT   COUNT (*), customer_number, branch_id
    FROM pos_customers_pos_vr
GROUP BY customer_number, branch_id
  HAVING COUNT (*) > 1;

and i want to create a delete statement based on it

- i 've tried this ,

delete from pos_customers_pos_vr 
where exists ( SELECT   COUNT (*), customer_number, branch_id
    FROM pos_customers_pos_vr
GROUP BY customer_number, branch_id
  HAVING COUNT (*) > 1);

but it deletes all rows in the table .

- sorry for not posting create and insert statements , i think no need for it , i am asking about the rule ,

how to delete based on a select statement ?

This post has been answered by Paulzip on Sep 1 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 29 2016

Added on Sep 1 2016

14 comments

1,969 views