1、select top 2 * from (select top 3 * from users order by uid) as a order by uid desc2、select top 2 * from (select top 3 * from users ) as a order by uid desc这两条语句单独执行括号里的子语句结果是一样的,可执行整个的话,两条语句的结果却是不同的了。
难道是第二条外面的desc把括号里面的顺序也影响了?
难道是第二条外面的desc把括号里面的顺序也影响了?
一个没指定
单独执行一样可能只是凑巧而已,数据换换也许就不同了
没必要纠结