TSQL - TOP X in FROM Subquery?
Posted
by EWizard
on Stack Overflow
See other posts from Stack Overflow
or by EWizard
Published on 2010-05-07T20:14:16Z
Indexed on
2010/05/07
20:18 UTC
Read the original article
Hit count: 619
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
© Stack Overflow or respective owner