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