Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

delete row in itab

Former Member
0 Likes
638

Hallow

I wont to delete from my internal table value with persg <> 6 or 7 or 8

I try like that but it delete data in my table with persg 6 7

How I can delete all the row in my table with 6, 7,8 in persg

This is my trying

and its not working

DELETE person_tab WHERE ( persg <> 6 OR persg <> 7 OR persg <> 8 ).

regards

1 ACCEPTED SOLUTION
Read only

alex_m
Active Contributor
0 Likes
617

Try this,

DELETE person_tab WHERE ( persg <> 6 AND persg <> 7 AND persg <> 8 ).

Hallow

I wont to delete from my internal table value with persg <> 6 or 7 or 8

I try like that but it delete data in my table with persg 6 7

How I can delete all the row in my table with 6, 7,8 in persg

This is my trying

and its not working

DELETE person_tab WHERE ( persg <> 6 OR persg <> 7 OR persg <> 8 ).

regards

5 REPLIES 5
Read only

Former Member
0 Likes
617

hi,

do this way

DELETE person_tab WHERE ( persg <>' 6'  OR persg <> '7' OR persg <>' 8' ).

Regards,

Santosh

Read only

Former Member
0 Likes
617

DELETE person_tab WHERE ( persg <> 6 AND persg AND 7 OR persg AND 8 )

is the correct one...

reward if helpful...

Read only

Former Member
0 Likes
617

Try this..

DELETE person_tab WHERE ( persg <> '6' OR persg <> '7' OR persg <> '8' ).

Reward points if useful...

Cheers,

Sam

Read only

alex_m
Active Contributor
0 Likes
618

Try this,

DELETE person_tab WHERE ( persg <> 6 AND persg <> 7 AND persg <> 8 ).

Read only

Former Member
0 Likes
617

Hi,

write:

DELETE person_tab WHERE ( persg >= 6 and persg <= 8 )

you can put them in range and write:

DELETE person_tab WHERE persg in r_numbers.

or write 3 times:

DELETE person_tab WHERE persg = 6.

DELETE person_tab WHERE persg = 7.

DELETE person_tab WHERE persg = 8.

regards,

Anji