Hi All,

I have a following query How can i do:

select tckno from issues where id=(select max(id) from issues);

Do I need to Write the Query Twice like first for

1. selecting the max(id). Then
2. Selecting the tckno.


Or How can I do it at once. Also How Can I use the functions in Hibernate like : between, in, max, count etc.

Hi

use sqlquery

session.createSQLQuery("select i.tckno from issues i where i.id=(select max(id) from issues)");

for more detail chapter 14.14. HQL examples

Amila

(Dont't forget to rate if helps)