469,150 Members | 1,969 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,150 developers. It's quick & easy.

a challenging query

hi to all,

please help me in the issue ,

rowno name city
2 sam chennai
4 suresh madurai
1 raja us
4 ravi california

i want to delete the first record of a table in which the rowno is repeated the same for many records, i want to delete exactly the 4,suresh,madurai row only as specified above not the 4,ravi,california.

could u please help me in oracle query, i do thankfull for u my friends.

by sam
Oct 5 '06 #1
1 1363
hi sam

this is very easy one.

Try this qry:

delete from tablename where rowno=4 and name='suresh' ;

OR Duplicate Rows Oracle Table

DELETE FROM our_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM our_table
GROUP BY column1, column2, column3... ;

Here column1, column2, column3 constitute the identifying key for each record.

By
Captain
Oct 5 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by LineVoltageHalogen | last post: by
11 posts views Thread by George | last post: by
5 posts views Thread by alainpoint | last post: by
1 post views Thread by mukeshrasm | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.