SQL Server 嵌套查询影响结果集顺序怎么解决？

[jiangnan_010203]

SQL Server 嵌套查询影响结果集顺序怎么解决？

[IEEE_China]

具体问题具体分析。

[jiangnan_010203]

SELECT TOP 50 id,(SELECT COUNT(0) FROM table2 WHERE tid = table1.id AND status = 1) num FROM table1 WHERE status > 1 ORDER BY date DESC SELECT TOP 50 id FROM table1 WHERE status > 1 ORDER BY date DESC

[专注or全面]

最外层排序吧

[jiangnan_010203]

引用 3 楼 x_wy46 的回复:

最外层排序吧

嗯

[jiangnan_010203]

SQL语句查询结果的顺序是由哪些因素决定