1,075
社区成员
发帖
与我相关
我的任务
分享
--以下为在sql server 中的写法.
create table tb(col varchar(30))
insert into tb values('[2007]RED-w150-112')
insert into tb values('[2007]RED-w150-1110')
insert into tb values('[2007]RED-w150-111')
insert into tb values('[2007]RED-w150-1109')
go
select * from tb order by cast(reverse(left(reverse(col) , charindex('-',reverse(col))-1)) as int)
/*
col
------------------------------
[2007]RED-w150-111
[2007]RED-w150-112
[2007]RED-w150-1109
[2007]RED-w150-1110
(4 行受影响)
*/
select * from tb order by cast(reverse(left(reverse(col) , charindex('-',reverse(col))-1)) as int) desc
/*
col
------------------------------
[2007]RED-w150-1110
[2007]RED-w150-1109
[2007]RED-w150-112
[2007]RED-w150-111
(4 行受影响)
*/
drop table tb