成功代码:
select
SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY blishTime desc ),',',1),
quiryId,max(blishTime)
from `otice` GROUP BY quiryId
以上每行sql结果为:
(quiryId分组后,每个分组最大blishTime所在行的id),quiryId,max(blishTime)
主要作用是GROUP_CONCAT函数将某字段拼接为字符串
成功代码:
select
SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY blishTime desc ),',',1),
quiryId,max(blishTime)
from `otice` GROUP BY quiryId
以上每行sql结果为:
(quiryId分组后,每个分组最大blishTime所在行的id),quiryId,max(blishTime)
主要作用是GROUP_CONCAT函数将某字段拼接为字符串