Hello,

I'm trying to implement a FIFO process. I need to always extract the row with the smallest c_id value. My first guess was to use a sql query with a subquery.

select * from table where table.id=( select min(table.id) );

I have searched the forums, but I have not found anything at all.

Thanks,

Sid

hibernate supports sub queries if your db does

Thanks for the reply. However, my app will work with different databases. And because not all of them support subqueries, we want to avoid them.

you could:

select * from Table order by id asc

and then use Query.setMaxResults(1) to get only the first row.