mysql 分组排序查询语句

Question

CREATE TABLE IF NOT EXISTS m_tabale (
id bigint auto_increment,
m_code VARCHAR(6),
m_date DATE,
m_val VARCHAR(256),
CONSTRAINT UC_Employee UNIQUE (m_code, m_date),
primary key(id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

m_code    m_date        m_val
000001  2023-01-01    wwwwww
000001  2023-01-02    weeeee
000001  2023-01-03    werrrr
000002  2023-01-01    weewww
000002  2023-01-02    wttwew
000003  2023-01-01    weewww
000003  2023-01-02    wttwew
000003  2023-01-03    wttwew

按照日期筛选每一天 且 m_val 排序 的前10条数据。是每一天的前10条哟

Answer 1

两字段唯一，是不是指的用code和date分组，count为1的记录啊但是你已经做约束了，不需要再做查询语句了啊可能我理解的不太对
select count(1) , m_code, m_date from m_tabale where 1=1 group by m_code, m_date having count(1) = 1