How to achieve the following sql query using HQL?

Question

I've the following sql query which I need to accommodate using HQL.

A is an Author and B is an Book - Author has Many books

SQL:

order by a.bookNbr desc, nvl(b.auth_name, b.last_name || ' ' || b.first_name))

Any help would be appreciated to convert above sql to HQL.

Take a look at this - http://stackoverflow.com/questions/601615/how-to-simulate-nvl-in-hql — gkamal, Jun 09 '13 at 05:27

score 0 · Answer 1 · answered Jun 09 '13 at 10:04

0

Did you try

order by a.bookNbr desc, coalesce(b.auth_name, b.last_name + " " + b.first_name))

answered Jun 09 '13 at 10:04

prayagupa

1 Answers1