create table [dbo].jqfk not null,
[yhh] char null,create table [dbo].jqfk not null,
[yhh] char null,
[cbrq] nvarchar null,
[ysl] [int] null,
)
[cbrq] [nvarchar](19) null,[ysl] [int] null,
)
insert into jqfk values ('b173022031201','2015-01-08 10:12:30',0);
insert into jqfk values ('b211001024011','2015-01-08 10:46:13',13);
insert into jqfk values ('b211001024012','2015-01-08 10:46:13',0);
insert into jqfk values ('b211001024013','2015-01-08 10:46:13',3);
insert into jqfk values ('b211001024014','2015-01-08 10:46:13',0);
insert into jqfk values ('b173022031201','2015-02-08 10:46:13',0);
insert into jqfk values ('b211001024011','2015-02-08 10:46:13',0);
insert into jqfk values ('b211001024012','2015-02-08 10:46:13',13);
insert into jqfk values ('b211001024013','2015-02-08 10:46:13',11);
insert into jqfk values ('b211001024014','2015-02-08 10:46:13',0);
insert into jqfk values ('b173022031201','2015-03-08 10:46:13',0);
insert into jqfk values ('b211001024011','2015-03-08 10:46:13',0);
insert into jqfk values ('b211001024012','2015-03-08 10:46:13',0);
insert into jqfk values ('b211001024013','2015-03-08 10:46:13',0);
insert into jqfk values ('b211001024014','2015-03-08 10:46:13',0);
insert into jqfk values ('b173022031201','2015-04-08 10:46:13',13);
insert into jqfk values ('b211001024011','2015-04-08 10:46:13',0);
insert into jqfk values ('b211001024012','2015-04-08 10:46:13',12);
insert into jqfk values ('b211001024013','2015-04-08 10:46:13',0);
insert into jqfk values ('b211001024014','2015-04-08 10:46:13',0);
我需要最后一次为0，且之后按时间倒序排序为0 的次数。其实需要的是最近一次为0的用户，他最近为0次数。
结果
1 b211001024014 4
2 b211001024011 3
3 b211001024013 2