刪除sql相同記錄的命令格式
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)))
- 上一篇：“城市物聯(lián)網(wǎng)密鑰管理系統(tǒng)”申領(lǐng),住建部全面放開 2020/4/10
- 下一篇：停車場(chǎng)系統(tǒng)設(shè)計(jì)原則 2014/9/19
滬公網(wǎng)安備 31011402002854號(hào)