【问题:对于表TestData:ID,Da...... 问题:对于表 TestData : ID, DataID, A,B,C 需要删除DataID重复的记录,仅保留第一条。 ID为Int型主键 delete * from TestData where ID not in ( select Min(ID) from TestData group by DataID ) |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 23:29 , Processed in 0.131408 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.