91啦中文在线I日本一级做a爱片I婷婷国产综合I欧美综合偷拍Iwww.91黄Iwww.wuyeI亚洲伊人精品Iavi亚洲无码I国产日逼视频I神马福利视频I东京热视频网I男人天堂久久

刪除sql相同記錄的命令格式

來源:譽(yù)澄智能 2014/11/20 12:07:46??????點(diǎn)擊:

elete YC_DispHis_Rec_tmp SELECT * INTO YC_DispHis_Rec_tmp FROM YC_DispHis_Rec WHERE (1 = 2) insert into YC_DispHis_Rec_tmp Select * from YC_DispHis_Rec SELECT * FROM YC_DispHis_Rec WHERE (申請人員 = '王擎123') DELETE FROM YC_DispHis_Rec WHERE (id NOT IN          (SELECT MAX(ID)         FROM YC_DispHis_Rec         GROUP BY 派車編號)) DELETE FROM YC_DispRec_Info WHERE (id NOT IN          (SELECT MAX(ID)         FROM YC_DispRec_Info         GROUP BY 派車編號))