注册 登陆
浏览模式: 标准 | 列表 Tag: sql语法

合并记录集 并删除

Written by 小锋 on 08-07-21 11:30 AM

DELETE FROM Tables WHERE ID NOT IN (SELECT Min(ID) FROM Tables GROUP BY Name)

Min的话 保留最小的

或者保留最大 那就改成Max即可

Tags: sql语法

Filed under: ASP 1 Comments 5623 Views

刚涉及到的SQL语法 替换

Written by 小锋 on 08-05-31 2:17 PM

UPDATE Friend set Name = REPLACE(Name,'大鸟','超级大鸟')超级简单

Tags: sql, 语法, sql语法, 替换

Filed under: SQL 0 Comments 4650 Views

丢一个sql语法

Written by 小锋 on 08-04-27 12:49 AM

select into 和 insert into select 两种表复制语句select * into destTbl from srcTbl

insert into destTbl(fld1, fld2) select fld1, 5 from srcTbl………………

» 阅读全文

Tags: sql语法, insert

Filed under: ASP 2 Comments 13766 Views