如何根据“，”排序

Question

本帖最后由 jishengzu 于 2010-06-14 12:35:57 编辑

Answer 1

select * from tb order by len([text]) - len(replace([text],',','')) desc

Answer 2

ORDER BY LEN(text)-LEN(REPLACE(text,',','')) DESC

Answer 3

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,')
goselect * from tb order by len([text]) - len(replace([text],',','')) descdrop table tb/*
text                 
-------------------- 
5,6,4,1,
2,3,4,
1,2,3,
1,
（所影响的行数为 5 行）*/

Answer 4

order by len([text]) - len(replace([text],',','')) desc