sql - 在特定的列中,SQL Server 如何对字母数字值进行 ORDER BY 处理

  显示原文与译文双语对照的内容

create table Employee(id int, Registration_no varchar(50),Name varchar(50))



insert into @Employee values(1,'DLW/TTC/19/3','RAMESH')


insert into @Employee values(2,'DLW/TTC/19/2','RAJEEV')


insert into @Employee values(3,'DLW/TTC/19/1','RUPAK')


insert into @Employee values(4,'DLW/TTC/19/4','RAMLAAL')


insert into @Employee values(5,'DLW/TTC/19/8','RITESH')


insert into @Employee values(6,'DLW/TTC/19/6','HRITIK')


insert into @Employee values(7,'DLW/TTC/19/9','ROSHAN')


insert into @Employee values(8,'DLW/TTC/19/7','RUPALI')


insert into @Employee values(9,'DLW/TTC/19/5','SHRISTI')


insert into @Employee values(10,'DLW/TTC/19/10','ROSHNI')



select * from Employee



你好,我有上面的表格。 实际上正在问问题,在试图订购这列表( Registration_no ),因这里请帮助我根据它的( Registration_no ) 列订购它。

其他列如何排列并不重要。 我只是希望我的Registration_no列按如下顺序排列


Registration_no


DLW/TTC/19/1


DLW/TTC/19/2


DLW/TTC/19/3


DLW/TTC/19/4


DLW/TTC/19/5


DLW/TTC/19/6


DLW/TTC/19/7


DLW/TTC/19/8


DLW/TTC/19/9


DLW/TTC/19/10



时间:

...