mysql - GROUP BY id_recruiter ORDER BY ID DESC 不起作用

Question

MySQL 结构
| 身份证 | id_recruiter | 日期创建 |
| 1 | 222 | 2018-08-15 |
| 2 | 222 | 2018-08-16 |
| 3 | 222 | 2018-08-17 |

MySQL 选择

SELECT * FROM table WHERE id_recruiter=222 GROUP BY id_recruiter ORDER BY ID DESC

结果：| 1 | 222 | 2018-08-15 |

我想得到最后一条记录：| 3 | 222 | 2018-08-17 |

请给我解决方案。太感谢了！

标签： mysql

Answer 1

试试下面的查询：使用 MAX 聚合

SELECT max(id) as id, id_recruiter,max(date_created) as date_created FROM table 
WHERE id_recruiter=222 
GROUP BY id_recruiter