Skip to Main Content
Forums

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!

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

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,525 views