SQL ÅÅÐòÎÊÌâ - MS-SQL Server / »ù´¡Àà

¸ø³ö±í
id timeSpan
1 5Ìì 10£º00£º00
2 20Ìì 01£º00£º00
3 100Ìì 01£º00£º00
¸ù¾ÝtimeSpanµÃµ½½á¹û
id timeSpan
1 100Ìì 01£º00£º00
2 20Ìì 01£º00£º00
3 5Ìì 10£º00£º00
»¹ÇóÒ»ÌìsqlÓï¾ä½â¾ö´ËÎÊÌâ

---

SQL code:

--> ²âÊÔÊý¾Ý£º[TB]
if object_id('[TB]') is not null drop table [TB]
create table [TB]([id] int,[timeSpan] varchar(20))
insert [TB]
select 1,'5Ìì 10:00:00' union all
select 2,'20Ìì 01:00:00' union all
select 3,'100Ìì 01:00:00'

select * from [TB] order by 2

/*
id timeSpan
----------- --------------------
3 100Ìì 01:00:00
2 20Ìì 01:00:00
1 5Ìì 10:00:00

£¨ËùÓ°ÏìµÄÐÐÊýΪ 3 ÐУ©


*/

drop table TB

---

SQL code:
order by
cast(left(timespan,patindex('%[ß¹-咗]%',timespan)-1) as int) desc,
right(timespan,8) desc

---

select * from [table] order by timeSpan desc

---

SQL code:

--ĬÈϵIJ»ÊÇÒѾ­ÓÐÒ»ÖÖÅÅÐòÁËÂð!
...........order by id desc

---

sorry !û¿´Çå!»¹ÊÇ1Â¥µÄ·½·¨ºÜºÃ!

---

ÒýÓÃ