阅读背景:

SQL-Server/Access - Order BY 1,2?

来源:互联网 

I came across a query today,

我今天遇到一个问题,

SELECT col1,'yes' as col2  FROM myTable  
   WHERE col2=TRUE  
UNION  
SELECT col1,'no' as col2 FROM mytable  
   WHERE col2=FALSE  
ORDER BY 1,2  
SE



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: