Hibernate Community • View topic - Need help to create Query with goup by

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Need help to create Query with goup by

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

dberkov

Post subject: Need help to create Query with goup by

Posted: Wed Jul 04, 2007 9:37 am

Newbie

Joined: Thu May 31, 2007 4:31 am
Posts: 5

Hi,
I want to make query with ICriteria/HQL like:
"Get first two cats with heavy weight from each color".
I can do it in MSSQL like

select cats.*
from
(select CATS.*, row_number() over (partition by COLOR order by WEIGHT desc) as SEQ
from CATS) cats
WHERE cats.SEQ <=2

Any idea?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum