趣味排序

原贴:  点击打开链接

SELECT ASCII('-') AS [-],ASCII('1') AS [1]/*-  145 49*/SELECT * FROM (  SELECT '-' AS t  UNION  SELECT '1' AS t  ) A  ORDER BY t/*-: 45, 1: 49 , 所以 - 在前 1 在后-1*/SELECT * FROM (  SELECT '-11' AS t  UNION  SELECT '11' AS t  ) A  ORDER BY t/*45 + 49 + 49 > 49 + 49 ， 所以 -11 在后11-11*/SELECT * FROM (  SELECT '-11' AS t  UNION  SELECT '111' AS t  ) A  ORDER BY t/*45 + 49 + 49 < 49 + 49 + 49-11111*/SELECT ASCII('a') AS [a],ASCII('b') AS [b],ASCII('c') AS [c],ASCII('z') AS [z]/*a    b    c    z97   98   99   122*/SELECT * FROM (  SELECT 'az' AS t  UNION  SELECT 'bc' AS t  ) A  ORDER BY t /*a+z > b+c , 为何 az 还是排到上面了？azbc*/