1.Mapper.xml文件
select address,count(address) as address_count from job51 GROUP BY address order by address_count desc
2.entity新增addressCount字段
@Data
public class Job51 implements Serializable {
private static final long serialVersionUID = 1L;
private String jobName;
private String companyName;
private String salary;
private String avgSalary;
private String address;
private String issuedate;
private String jobwelf;
private String companysize;
private String workYear;
private String education;
private String jobHref;
//新增的字段
private Integer addressCount;
}