等同于“限制不同"? [英] How to do equivalent of "limit distinct"?

问题描述

如何将结果集限制为给定列的 n 个不同值，而实际行数可能更高?

How can I limit a result set to n distinct values of a given column(s), where the actual number of rows may be higher?

输入表:

client_id, employer_id, other_value
1, 2, abc
1, 3, defg
2, 3, dkfjh
3, 1, ldkfjkj
4, 4, dlkfjk
4, 5, 342
4, 6, dkj
5, 1, dlkfj
6, 1, 34kjf
7, 7, 34kjf
8, 6, lkjkj
8, 7, 23kj

所需的输出，其中limit different = 5个不同的client_id值:

desired output, where limit distinct=5 distinct values of client_id:

1, 2, abc
1, 3, defg
2, 3, dkfjh
3, 1, ldkfjkj
4, 4, dlkfjk
4, 5, 342
4, 6, dkj
5, 1, dlkfj

该平台适用于MySQL.

Platform this is intended for is MySQL.

推荐答案

您可以使用子选择

select * from table where client_id in 
(select distinct client_id from table order by client_id limit 5)

这篇关于等同于“限制不同"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！