首页用hql实现SELECT * from expense_main a LEFT JOIN org_person b on a.Fd_expense_id =b.Fd_id where b.Fd_level =2 and a.Fd_create_date >= '2020-04-10' AND a.Fd_create_date <= '2020-05-10'ORDER BY a.Fd_amount DESC

用hql实现SELECT * from expense_main a LEFT JOIN org_person b on a.Fd_expense_id =b.Fd_id where b.Fd_level =2 and a.Fd_create_date >= '2020-04-10' AND a.Fd_create_date <= '2020-05-10'ORDER BY a.Fd_amount DESC

时间: 2023-04-07 15:03:27 浏览: 97

Hibernate_HQL.rar_hibernate HQL_hibernate hql src

对hibernate的hql进行了详尽的讲解

我可以回答这个问题。使用HQL语句实现该查询可以如下： SELECT a, b FROM ExpenseMain a LEFT JOIN a.orgPerson b WHERE b.level = 2 AND a.createDate BETWEEN '2020-04-10' AND '2020-05-10' ORDER BY a.amount DESC

用hql实现SELECT * from expense_main a LEFT JOIN org_person b on a.Fd_expense_id =b.Fd_id where b.Fd_level =2 and a.Fd_create_date >= '2020-04-10' AND a.Fd_create_date <= '2020-05-10'ORDER BY a.Fd_amount DESC

相关推荐

Hibernate-HQL.rar_HQL_hibernate hql

struts_hibernate_bbs.rar_bbs_hibernate b_hibernate bbs_struts hi

select * from t1 where not exist (select * from t2 where t2.wbsId = t1.wbsId) hibernate 实现

select * from t1 where not exist (select * from t2 where t2.wbsId = t1.wbsId) hibernate 实现 hibernate 5.6.1 Criteria API

quarkus entitymanager hql查询时报错： m_tenant is not mapped [from m_tenant where tenantId = :tenantId ]

org.hibernate.hql.internal.ast.QuerySyntaxException: user is not mapped [from user where id=?]

java.lang.ClassNotFoundException: org.hibernate.hql.spi.id.IdTableSupport

StringBuilder hql=new StringBuilder(); hql.append("select 1 "); hql.append(" from smsserver_out "); hql.append(" where status!='U' and user_id in(:affairIds)"); 写一条sql 要求是affairIds可能是1或者2或者3

hql 支持left join on 吗？

HQL str_to_map()方法使用

StringBuilder hql=new StringBuilder(); hql.append("select status "); hql.append(" from smsserver_out "); hql.append(" where status!='U' and user_id:=affairIds"); Map<String, Object> param = new HashMap<>();如果affairIds为多个参数的话 该怎么改

HQL string_to_map()使用

hql to_date

hql group by用法mySQL_HQL语言order by语句与group by子句使用实例

hql current_group函数用法

hql date_sub

hql rank_over

hql months_between

Hql date_sub

最新推荐

Hibernate_二级缓存总结

一个简单的java游戏.zip

平尾装配工作平台运输支撑系统设计与应用

管理建模和仿真的文件

MATLAB遗传算法探索：寻找随机性与确定性的平衡艺术

如何在S7-200 SMART PLC中使用MB_Client指令实现Modbus TCP通信？请详细解释从连接建立到数据交换的完整步骤。

MAX-MIN Ant System：用MATLAB解决旅行商问题

"互动学习：行动中的多样性与论文攻读经历"

【实战指南】MATLAB自适应遗传算法调整：优化流程全掌握

在Spring AOP中，如何实现一个环绕通知并在方法执行前后插入自定义逻辑？

StringBuilder hql=new StringBuilder(); hql.append("select status "); hql.append(" from smsserver_out "); hql.append(" where status!='U' and user_id:=affairIds"); Map<String, Object> param = new HashMap<>();如果affairIds为多个参数的话该怎么改