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
相关文章