SELECT * FROM (SELECT * FROM t_company_product ORDER BY publish_date DESC) temp where verify = 1 GROUP BY company_id ORDER BY publish_date DESC limit 10;
...全文
762打赏收藏
mysql sql转换为HQL
SELECT * FROM (SELECT * FROM t_company_product ORDER BY publish_date DESC) temp where verify = 1 GROUP BY company_id ORDER BY publish_date DESC limit 10;