1

@Query(nativeQuery=true,value = "")

1

2

3

4

5

6

public interface GaidDao extends LogicDeleteableRepository<Gaid, Long>, JpaSpecificationExecutor<Gaid> {

    //加入：nativeQuery注解时，写原生sql，支持limit函数

    //不加入：nativeQuery注解时是JPQL。JPQL不支持limit函数

    @Query(nativeQuery=true, value = "select gaid from sdp_gaid where geo = ?1 and deleted = 0 order by id desc limit 1000000")

    List<String> findGaidByGeo(String geo);

}

1

2

@Query(value = "select * from d_quarterly_report where report_type=?1 order by cycle_number desc limit 1" ,nativeQuery = true)

    QuarterlyReport getLastUploadByReportType(Boolean type);

1

2

@Query(value = "select * from d_quarterly_report where report_type=?1 order by cycle_number desc limit 0,1",nativeQuery = true,)

    QuarterlyReport getLastUploadByReportType(Boolean type);