仅选择满足指定条件的组的前两行

使用 ROW_NUMBER() ,并为选择最早的2条记录 ABC 和 YQA 代码,按顺序 ID .

WITH cte AS (
    SELECT t.*, ROW_NUMBER() OVER (PARTITITON BY Code ORDER BY ID) rn
    FROM yourTable t
    WHERE Code IN ('ABC', 'YQA')
)

SELECT ID, Name, Code
FROM cte
WHERE rn <= 2
ORDER BY Code, Id;

使用row_number

 with t as 
    (select *, 
         row_number()  over (partition by survey) as idx 
     from table 
     where code in ('ABC','YQA')) 
select id, name, code from t where idx < 3;