深圳网站建设技术博客

 sql="select distinct(wt_BatchNumber) ,wt_addUser,wt_addtime from wd_no where "&sqlstr1&" order by  wt_addtime desc    "

More...

SQL语句如下：

DELETE FROM T_S_POS_SHOPRECODE A
    WHERE (A.POSID, A.SHOPTIME, A.CARDID) IN
    (
     SELECT POSID, SHOPTIME, CARDID
     FROM T_S_POS_SHOPRECODE

More...