jpa执行原生sql union bug解决

@Query(value = "SELECT * FROM count_entity where id=-1111 union (SELECT * FROM count_entity where video_name = ?1 AND platform ='腾讯视频' ORDER BY click_date DESC LIMIT ?2)"
+ "UNION"
+ "(SELECT * FROM count_entity where video_name = ?1 AND platform ='爱奇艺' ORDER BY click_date DESC LIMIT ?2)"
+ "UNION"

+ "(SELECT * FROM count_entity where video_name = ?1 AND platform ='芒果TV' ORDER BY click_date DESC LIMIT ?2)", nativeQuery = true)


union前面需要连接一个空数据查询,因为union 第一个查询不能用()


版权声明:本文为LQW_java_home原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。