高分求解SQL语句 - MS-SQL Server / 疑难问题

对于数据库中的两条数据
1-5.1
1-5.10
1-5.9
如何实现查旬结果按照从小到大的排序
1-5.1
1-5.9
1-5.10

---

SQL code:
if not object_id('tb') is null
drop table tb
Go
Create table tb([col] varchar(10))
Insert tb
select '1-5.1' union all
select '1-5.10' union all
select '1-5.9'
Go
select *
from tb
order by left(col,charindex('.',col)-1)
,cast(right(col,len(col)-charindex('.',col))as float)asc
/*
col
----------
1-5.1
1-5.9
1-5.10
*/

---

SQL code:
--> 生成测试数据表: [tb]
IF OBJECT_ID('[tb]') IS NOT NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb] ([col] varchar(10))
INSERT INTO [tb]
SELECT '1-5.1' UNION ALL
SELECT '1-5.10' UNION ALL
SELECT '1-5.9' UNION ALL
SELECT '1-3.9' UNION ALL
SELECT '1-3.12' UNION ALL
SELECT '1-3.3'

--SELECT * from [tb]

-->SQL查询如下:
select * from tb order by left(col,charindex('.',[col])),stuff(col,1,charindex('.',[col]),'')*1
/*
col
----------
1-3.3
1-3.9
1-3.12
1-5.1
1-5.9
1-5.10

(6 行受影响)
*/

---

select * from tb
order by cast(replace(col,'-','0') as decimal)

---

SQL code: