Changes between Initial Version and Version 1 of Ticket #72


Ignore:
Timestamp:
12/06/2011 01:42:44 PM (14 years ago)
Author:
chenchongqi
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #72

    • Property Status changed from new to closed
    • Property Resolution changed from to fixed

  • Ticket #72 – Description

    initial v1  
    1313{{{ 
    1414DELETE FROM PDL_PRODUCT_PIC A WHERE A.TYPE IN(3,13,5,11,12) AND ID NOT IN( 
    15 SELECT MAX(ID) FROM PDL_PRODUCT_PIC B WHERE A.PRODUCT_ID = B.PRODUCT_ID AND A.TYPE = B.TYPE and  
    16 b.upload_date>sysdate - interval '20' MINUTE) 
     15SELECT MAX(ID) FROM PDL_PRODUCT_PIC B WHERE A.PRODUCT_ID = B.PRODUCT_ID AND A.TYPE = B.TYPE  
     16and b.upload_date>sysdate - interval '20' MINUTE) 
    1717}}} 
    1818