php - Mysql ORDER BY COUNT(* ) 获取最旧的行

Question

你能帮我吗？我愿意

1) 检查 tb_pre_sale 中的 id 是否不存在于列 seler_0 上，或者存在但未重复至少 2 次

2) 获取最旧的一个

谢谢!

 SELECT DISTINCT seller_0 
 FROM tb_pre_sale 
 WHERE seller_0 !=? 
 GROUP BY id 
 ORDER BY COUNT(*) < ? DESC

Answer 1

 SELECT seller_0 
 FROM tb_pre_sale 
 WHERE seller_0 !=? 
 GROUP BY  seller_0 
 HAVING COUNT(*) < ? ORDER BY seller_0 DESC