为计算为true的IN条件元素设置限制

SELECT * FROM users WHERE status IN ('active', 'pending');

SELECT * FROM users 
WHERE status IN ('active', 'pending') 
AND id IN (
    SELECT id 
    FROM users 
    WHERE status IN ('active', 'pending') 
    LIMIT 100
);

WITH ranked_users AS (
    SELECT *, ROW_NUMBER() OVER (ORDER BY id) AS rn
    FROM users 
    WHERE status IN ('active', 'pending')
)
SELECT * FROM ranked_users 
WHERE rn <= 100;

-- 查询状态为 'active' 或 'pending' 的用户，并且数量不超过 100
SELECT * FROM users 
WHERE status IN ('active', 'pending') 
AND id IN (
    SELECT id 
    FROM users 
    WHERE status IN ('active', 'pending') 
    LIMIT 100
);