MySQL 最低排序和分组依据

Question

表格数据:从用户中选择firstName、package_id、网站

请注意，表中有超过 30k 行。

我试图在每个网站中显示最低的package_id，这里是查询

select firstName, package_id, website from user group by website order by package_id

它应该显示每个网站的最低 package_id，但它不正确，例如对于值 kahuta 它应该返回 6 和对于 Null => 10和 example.com => 9

Answer 1

如果不存在:

select u.* from user u
where not exists (
  select 1 from user
  where website <=> u.website and package_id < u.package_id
)

或将表连接到子查询，该子查询返回每个网站的min package_id:

select u.* 
from user u inner join (
  select website, min(package_id) minpackageid
  from user 
  group by website
) g on g.website <=> u.website and g.minpackageid = u.package_id