SELECT: can this be done with Criteria API?

johngrinder · **Joined:** Sun Jan 13, 2008 6:48 am **Posts:** 16

Hi Community,

i have a question regarding random selection of rows from a MSSQL server.

In SQL-code , i can write:

Code:

   SELECT TOP 1 column FROM table
   ORDER BY NEWID()

to select a random row from the table.

Unfortunately, i seems like this type of query can't be done with criteria API?

Regards

johngrinder · **Joined:** Sun Jan 13, 2008 6:48 am **Posts:** 16

I don't know if this is the correct forum-section? Perhaps someone of the Mods. can move this question into the Standard-Hibernate-API?

wolli · **Posted:** Fri Jun 26, 2009 9:14 am

I don't think that's possible. I suggest you post your question here:

http://groups.google.com/group/nhusers?hl=en