欧美日韩国产精品一区综合在线-亚洲av在线播放网址大全-久久影院午夜伦手机不四虎卡-中文字幕人妻丝袜乱一区三区-97热精品视频免费视频-人妻少妇精彩视品一区二区三区-污污污网站在线免费看-忘忧草社区在线播放日本韩国-亚洲精品一区二区三区婷婷月

刪除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 (申請(qǐng)人員 = '王擎123') DELETE FROM YC_DispHis_Rec WHERE (id NOT IN          (SELECT MAX(ID)         FROM YC_DispHis_Rec         GROUP BY 派車編號(hào))) DELETE FROM YC_DispRec_Info WHERE (id NOT IN          (SELECT MAX(ID)         FROM YC_DispRec_Info         GROUP BY 派車編號(hào)))