How to convert SQL subquery to HQL?

Question

I have asked a question here

The solution is :

select * from table_name t
inner join 
    (select max(seq) seq, row_name from table_name group by row_name) t1 on t1.row_name = t.row_name and t.seq = t1.seq

But I need to convert it to HQL. The solution uses a subquery in FROM which is not allowed in HQL.

How can I convert the subquery to HQL using SELECT or WHERE?

Thanks.

yo can't have this syntax on HQL , you can add a view for your subquery and then map it on a model then join it in your query . — Mohammad Mirzaeyan, Dec 04 '19 at 07:00

majurageerthan · Answer 1 · 2019-12-04T14:44:17.343

You can achieve your goal through Hibernate Native Query, see this

Try this

List<Object[]> objects = session.createNativeQuery(
                "select * from table_name t"
                + "inner join"
                + "(select max(seq) seq, row_name from table_name group by row_name) t1"
                + "on t1.row_name = t.row_name and t.seq = t1.seq")
.list();

This example shows using subquery in HQL through native query

How to convert SQL subquery to HQL?

1 Answers1