SQLÅÅÐòÎÊÌâ

bomlevel Ϊ×Ö·û´®,ÓеÄÓÐÁ½¸öСÊýµã»ò¸ü¶à
ͨ¹ýorder by bomlevel  ½á¹ûÈçÏÂͼ.

µ±ÖÐ1.10ºÍ1.11Åŵ½Ç°ÃæÈ¥ÁË,Ó¦¸ÃÅŵ½1.9ºóÃæ²Å¶Ô.

---

¿´²»µ½Í¼¡£¡£¡£¡£¡£¡£¡£¡£

---

SQL code:
order by cast(bomlevel as dec(18,2))

---

ͼƬÈçÏÂ

---

ÒýÓÃ

SQL codeorderbycast(bomlevelasdec(18,2))

´íÁË£¬ÊÔÊÔ

SQL code:
order by len(bomlevel),bomlevel

---

SQL code:
if object_id('[tb]') is not null drop table [tb]
go
create table [tb]([bomlevel] varchar(10))
insert [tb]
select 1.10 union all
select 1.11 union all
select 1.9


select * from [tb] order by len(bomlevel),bomlevel

/**
bomlevel
----------
1.9
1.10
1.11

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

**/

---

ͼƬÀÏÊDz»³öÀ´,Ö»ÓÐÊÖ¹¤ÅÅÁË,
Ï£ÍûÄÜʵÏÖ:
°´bomlevel×ֶΰ´ÁÐ
½á¹ûÈçÏÂ:
1
1.1
1.2
1.3
1.3.1
1.3.2
1.4
1.5
....
1.10
1.11
×¢Òâ²»ÄÜת»»³ÉÊý×Ö,ÒòΪbomlevelµÄСÊýµã¿ÉÄܶàÓÚÁ½¸ö.

ÏÈллÁË.

ID    bomlevel ParentId subID