sql--Delete repeated items from a table
来源:互联网 发布:新媒体营销 数据分析 编辑:程序博客网 时间:2024/05/21 10:40
Create Table temp_emp
(
[Name] [varchar](500) NULL,
[Type] [varchar](50) NULL,
[Comment] [varchar](1000) NULL
)
insert into temp_emp([Name],[Type],[Comment])
select distinct resource.[Name],resource.[Type],resource.Comment
from resource
truncate table resource
insert into resource select * from temp_emp
Drop table temp_emp
- sql--Delete repeated items from a table
- Efficiently Delete / Purge All Items from a SharePoint List
- delete many rows from a large table
- SQL: CREATE a table from another table
- SQL数据库 "TRUNCATE TABLE" "DELETE FROM TABLE" 的区别
- SQL: DELETE FROM FROM
- Truncate Table 与DELETE FROM
- delete table 与delete from table truncate table 的区别
- delete from table & truncate table 的区别
- How to make a random selection from an SQL table
- Truncate table,Delete From table,与Drop table的区别
- TRUNCATE TABLE和DELETE FROM区别
- TRUNCATE TABLE和DELETE FROM区别
- 使用DELETE ADJACENT DUPLICATES FROM <table>注意
- delete from和truncate table的区别
- TRUNCATE TABLE和DELETE FROM区别
- delete from和truncate table的区别
- delete from和truncate table的区别
- 字符数组初始化
- smart工作流管理系统自动生成的页面和数据的效果示意图
- MySQL入门
- 利用Socket进行Java网络编程
- Asp.Net从零开始学-22
- sql--Delete repeated items from a table
- 除了魁北克城和蒙特利尔以外的魁省
- C#资料整体目录
- 识别’低效执行’的SQL语句 -转贴来自http://dev.csdn.net/develop/article/20/20143.shtm
- 转 三步学会Java Socket编程
- ajax定时器
- 欧洲穷游儿在加拿大安省的一礼拜
- 人权和公民权宣言
- 评一个失控项目