SQL Server中order by 字段*1什么意思？sql如下

Question

SELECT * FROM ( 
SELECT TBL.SKU AS SKU ,
LTRIM(S.SYOHINNAME) AS SYOHINNAME, 
TBL.BAIKA AS BAIKA, 
SUM(TBL.SURYO) AS SURYO 
FROM 
( SELECT REPLACE(LTRIM(REPLACE(LEFT(LTRIM(G.SKU),8), '0', ' ')), ' ', '0') AS SKU , 
G.BAIKA AS BAIKA, 
G.SURYO AS SURYO 
FROM GENDAT G
WHERE UPPER(LTRIM(RTRIM(G.AREA))) <> 'Z' 
) TBL 
LEFT OUTER JOIN SYOHINM S ON LTRIM(S.SKU) = TBL.SKU 
GROUP BY TBL.SKU,LTRIM(S.SYOHINNAME),TBL.BAIKA 
) AS TBL 
ORDER BY sku*1

Answer 1

按照第一列排序。。。。。