Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

help required to wrire a query.

Roy4321Dec 4 2009 — edited Dec 8 2009
Hi,
I have the below data

TableA

name----id----status
mat----123---- 1
mat----123---- 2 -- to be deleted
mat----123---- 2 -- to be deleted
sam----456---- 2
sam----456---- 2 -- to be deleted
dan----789---- 1
dan----789---- 1 -- to be deleted
dan----789---- 2 -- to be deleted
pan----111---- 1


can someone give me an idea how to write a query that delletes the records marked as "-- to be deleted"

Thanks,
Mathew

Edited by: roymathew432@yahoo.com on Dec 4, 2009 12:21 AM

Comments

InoL
Answer

See:

Marked as Answer by Runrig · Oct 15 2021
Runrig

Thank you that did the trick :-)

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2010
Added on Dec 4 2009
16 comments
1,514 views