写一句SQL取出按各年龄段（每10岁一个分段，如：[0,10),[10,20),[20,30)...

您好，

SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 0 AND age <10
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 10 AND age <20
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 20 AND age <30
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 30 AND age <40
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 40 AND age <50
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 50 AND age <60
UNION 
SELECT TOP 1 PERCENT age, user_id FROM users WHERE age >= 60;