摘要： 创建日志表CREATE TABLE [dbo].[Log]( [ID] [int] IDENTITY(1,1) NOT NULL, [Date] [datetime] NOT NULL, [Thread] [varchar](255) NOT NULL, [Level] [varchar](20) NOT NULL, [Logger] [varchar](255) NOT NULL, [Message] [varchar](4000) NOT NULL) ON [PRIMARY]--------------------------------------------------------配. 阅读全文

摘要： with t as (select id,uid,name,count(id) over (partition by userlist.id) r from userlist)select * from t where r>1如果要查询不重复的记录则with t as (select id,uid,name,rank() over (partition by userlist.id order by userlist.id desc) r from userlist)select * from t where r=1 阅读全文