VARCHAR type sorting about Sybase

xiaoxiao2021-03-06  73

1> Select * from idid Order by 12> Go ID ---- 1 10 11 2 20

(5 rows affected) 1> Select * from IDID ORDER by Convert (Integer, ID) 2> Go ID ---- 1 2 10 11 20

(5 rows affected) 1>

转载请注明原文地址:https://www.9cbs.com/read-120851.html

New Post(0)