group/order/having/exists条件
最后更新:2024-09-29 05:30:09
|
状态:未完成
group/order/having/exists都可以放在query参数中,与查询条件混在一块，如
service.query("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】
service.query("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】
