22,206
社区成员
发帖
与我相关
我的任务
分享
1、select convert(char(10),getdate(),120)
2、
select *
from (select rownumber() over (partition by id order by id) as taoistong , * from tb )t
where taoistong =1
select * from tb t where not exists (select * from tb where name=t.name and userid<t.userid)
select * from tb t
where not exists(select * from tb where userid=t.userid and id>t.id)
select convert(varchar(10),getdate(),120)
2009-10-27
(1 行受影响)