34,590
社区成员
发帖
与我相关
我的任务
分享
create table tb([text] varchar(20))
insert into tb values('1,2,3,')
insert into tb values('1,')
insert into tb values('')
insert into tb values('2,3,4,')
insert into tb values('5,6,4,1,')
go
select * from tb order by len([text]) - len(replace([text],',','')) desc
drop table tb
/*
text
--------------------
5,6,4,1,
2,3,4,
1,2,3,
1,
(所影响的行数为 5 行)
*/