Thread: Help in Query
View Single Post
Old 12-03-2009, 05:07 PM   #2 (permalink)
shahzadwasli
 
Join Date: Dec 2009
Posts: 10
Thanks: 0
Thanked 0 x in 0 Posts

Points 20 Level 1
Points: 20, Level: 1 Points: 20, Level: 1 Points: 20, Level: 1
Activity: 5%
Activity: 5% Activity: 5% Activity: 5%
Re: Help in Query
DELETE FROM
tbl A
WHERE
A.rowid >
ANY (SELECT B.rowid
FROM
tbl B
WHERE A.col1 = B.col1
AND A.col2 = B.col2
.....);

Lego Instructions
shahzadwasli is offline   Reply With Quote

 
 
[Output: 9.50 Kb. compressed to 9.23 Kb. by saving 0.28 Kb. (2.92%)]