SQL 数据库分页 删除重复记录

推荐资料自学网址:http://www./study.asp?vip=10241777 

--分页显示记录

declare @start int,@end int ,@sql  nvarchar(600)
set @start =1
set @end=50
set @sql='select top'+str(@end-@start+1)+' *  from 表单名资料表   where  int   not  in                       (select top '+str(@start-1)+' int  from 表单名资料表 where int>-1)'
 exec (@sql)

--提前五分钟提醒
SQL: select * from A where datediff('minute', 开始时间,getdate())>5

--说明：删除重复记录
delete from tablename where id not in (select max(id) from tablename group by col1,col2,...)