I was wondering if there is a way for a
SELECT query to be made on each matched value found within IN.
Consider that the table below contains 100 records for each of the values included referenced by the
INoperator, I'd like only 50 to be returned for each match.
SELECT TOP (50) COLUMN FROM TABLE WHERE COLUMN IN (1,2,3)
Is there an efficient way I can do this?
The only way I could think of is to execute the query for each value within
IN which would be way too slow considering the actual query retrieves many column from various tables.