Hi,
i need to build a sql statement using DetachedCriteria which has to look like this:

select id from (
select
table.ID as id
from
EXAMPLE_TABLE table
where table.PARAM = 1
order by table.TIMESTAMP desc
)
)

How can i do this? Or is it not possible with DetachedCriteria? I know how to create a subquery, but in a subquery i couldnt use the "order by", and that is necessary!