mysql 根据多个条件分组 多个条件排序

mysql 根据多个条件分组 多个条件排序

案例

mysql 根据多个条件group by 多个条件order by
平台端：查询用户搜索记录，包括逻辑删除数据

SELECT
	id,
	customer_id,
	search_keywords,
	COUNT( 1 ) AS search_times,
	sort,
	create_user,
	create_dept,
	DATE_FORMAT( create_time, '%Y-%m-%d' ) AS create_time,
	update_user,
	update_time,
	`status`,
	is_deleted 
FROM
	goods_user_search_records 
GROUP BY
	search_keywords,
	DATE_FORMAT( create_time, '%Y-%m-%d' ) 
ORDER BY
	DATE_FORMAT( create_time, '%Y-%m-%d' ) DESC,
	search_times DESC