oracle除第一行之外全部删除,sql – 删除除一些行之外的所有行 – Oracle

我想从表中删除一组行.我可以决定哪些行需要删除.只有当行数大于5(基于条件)时,我才会从表中删除行.

考虑这个示例数据

ID--Col1--Col2--

1 A X

2 A X

3 A X

4 A X

5 A X

6 A X

7 A X

8 A X

9 A X

10 A X

11 B X

12 B X

13 B X

14 B X

15 C X

16 C X

17 C X

18 D X

19 D X

我想删除5行{*,A,X},我需要保留5行(无论哪一行).我不会删除B,C& D因为它们的数量小于5.

喜欢

delete from tableA

--- I can decide on the rows to delete based on two conditions.

where col1 = someCondition

and col2 = someOtherCondition

and rownum > 5 --- This dint work. I checked.

我想也许我需要programmaticaly.任何建议都非常感谢.