I have some experience in SQL, but my knowledge in HQL is very limited Here is my SQL query select * from (select * from readings join (select max(signal) as signal,sender as mac ,receiver as rc from readings where created_datetime between ‘2018-02-05 10:25:52’ AND ‘2018-04-05 10:25:52’ grou…

Just run the SQL query. Why do you want to translate it to HQL? HQL does not support derive tables anyway.

HQL Hibernate INNER JOIN SUBQuery

Koushik_Paul August 2, 2018, 4:36pm 4

Okay.

Could you please tell me , what other options I have, where I will receive the output as an object of the DTO…

Topic		Replies	Views
How can I create a Join on a subquery with an aggregation (without correlation) Hibernate ORM	2	1215	November 18, 2018
Regarding Subquery in JPQL,please help me on this Hibernate ORM	1	1329	August 23, 2023
Hibernate Query Hibernate ORM	1	544	August 14, 2023
Is it possible to SELECT SUM(x) FROM (Subquery) in recent versions of JPA/Hibernate? Hibernate ORM	4	1640	October 7, 2024
Self Join using criteria query Hibernate ORM	3	1963	December 13, 2022