如何在mysql中进一步过滤GROUP BY记录？

请检查我想要查询id“43”的完整行（以及另一个nic_id最大query_id行）的图像，但它只给我最大query_id，我尝试了不同的查询，例如：

SELECT `Query_id`, `nic_id`, `date`, `subject`, `followup_no`, MAX(Query_id) as queryid FROM `sales_queries` GROUP BY `nic_id` HAVING MAX(`Query_id`)

SELECT `Query_id`, `nic_id`, `date`, `subject`, `followup_no`, MAX(Query_id) as queryid FROM `sales_queries` WHERE  GROUP BY `nic_id` HAVING MAX(`Query_id`)

SELECT  `Query_id`, `nic_id`, `date`, `subject`, `followup_no`, MAX(Query_id) as mxqueryid    FROM `sales_queries`WHERE `Query_id` = (SELECT MAX(`Query_id`) FROM `sales_queries`) GROUP BY `nic_id` 

when customer visit again followup increase(+1) with his same nic_id with different subject.

我想要完整的 43 行，主题为“Registration4”，日期等

NOT THIS, it should be Registration4 date:2015-09-11

与答案类似这个问题 https://stackoverflow.com/questions/31597492/mysql-subqueries-and-max-or-group-by，您可以使用子查询和连接来获取您想要的结果。类似以下内容应该有效：

SELECT `Query_id`, `nic_id`, `date`, `subject`, `followup_no`
FROM `sales_queries` AS sq
INNER JOIN (
    SELECT MAX(`Query_id`) AS mId
    FROM `sales_queries`
    GROUP BY `nic_id`
) AS subsq ON subsq.mId = sq.Query_id