group/order/having/exists条件

发布日期:2024-09-28
最后更新:2026-02-18 19:49:45
阅读:5,376
group/order/having/exists都可以放在query参数中,与查询条件混在一块,如
service.select("SSO_USER AS M", "order by id desc", "group by type", "exists(SELECT * FROM HR_USER AS H WHERE H.ID = M.ID)")
因为exists会涉及到动态条件,所以可以先构造RunPrepare,参考【exists