本文介绍了TSQL - FROM子查询中的TOP X?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
有人可以告诉我一种过滤位于 FROM 子句中的子查询的方法吗?我希望它看起来像这样:
Can someone please enlighten me to a way to filter a subquery that is located in a FROM clause? I would like it to look something like this:
SELECT *
FROM TABLE_A
LEFT JOIN (TOP 8 TABLE_B) ON TABLE_B.id = TABLE_A.id
推荐答案
请试试这个:
SELECT
column_names
FROM
TABLE_A A LEFT JOIN (SELECT TOP 8 column_names FROM TABLE_B) as B
on A.Id=B.ID
注意事项:
不要使用 *，因为它会导致性能限制.
Do not use * since it would lead to performance constraints.
如果您只关心 ID，则仅从 Table_B 获取 ID
IF you are concerned about just the ID then get only the ID from Table_B
HTH
这篇关于TSQL - FROM子查询中的TOP X?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！