sql查询如果除了pid其他的数据都一样，怎么取最新的

HAVING b.pid = (SELECT MAX(pid) from t_multi_hi_report WHERE report_org_name = b.report_org_name and report_org_code = b.report_org_code )