Spring Data Jpa 方法是這樣的:@Query("select pb.id,pp.max_borrow_amt,pp.min_borrow_amtfrom product_loan_basic pb left join product_loan_price pp on pb.code=pp.product_code where pb.code IN(?1) and pb.status='publish' order by ?2 ",nativeQuery = true) List<Object[]> findByCodesIn(List<String> codes,String orderby);那么 order by 是“ max_borrow_amt desc ”,但這是無(wú)效的。列表是無(wú)序的。
Spring 數(shù)據(jù) JPA nativeQuery order by 無(wú)效
慕無(wú)忌1623718
2021-08-04 15:11:02