Hibernate Criteria Query

sumitchawla76 · **Joined:** Wed Apr 20, 2011 5:08 pm **Posts:** 3

I am new to hibernate and I have a issue.
I have a Query SQL (select max(col1,col2,col3...) from table name where pkid in (id1,id2,id3...)
and then I need to extract the Max data from result. Means if 10 rows are returned I need the Max Value.

I need to know how to write a hibernate query for that
Any help is appreciated

Thanks

Smiley

thangaraj · **Joined:** Fri Apr 22, 2011 10:16 am **Posts:** 6

Hi please check your query(max function cannot contain more then one column).Then say you'r requirement i will help you

sumitchawla76 · **Joined:** Wed Apr 20, 2011 5:08 pm **Posts:** 3

The Max Function can Contain more than one col in a query. It is valid SQL and I am able to get the result.

thangaraj · **Joined:** Fri Apr 22, 2011 10:16 am **Posts:** 6

Ok but i execute this query in oracle
select max(MARKS1,MARKS2) from student
it shows invalid number of arguments.
please give table structure and you'r query.

sumitchawla76 · **Joined:** Wed Apr 20, 2011 5:08 pm **Posts:** 3

Try this in DB2 and that will work

ed1122 · **Joined:** Thu May 05, 2011 4:45 am **Posts:** 3

Any help is appreciated