i'm not sure exactly how to do this but i'm sure it must be simple. here is the sql:

select * from table1
where id =
(select min(id) from table1 where > 'some_number')

more curious how to implement subselect

thank you

From the docs:

See section 14.12 of reference.pdf
http://www.hibernate.org/hib_docs/v3/reference/en/pdf/hibernate_reference.pdf

thanks but I meant with criteria not hql

session.createCriteria(Student.class)
.add( Subqueries.propertyEqAll("name", dc) )
.list();

check out <hibernate-3.1>\test\org\hibernate\test\criteria\CriteriaQueryTest.java

for more details.

getting closer i think but:

Criteria criteria = session.createCriteria(ClassName.class);

DetachedCriteria dc = DetachedCriteria.forClass(ClassName.class)
.add(Restrictions.gt("id", new Integer(id)))
.setProjection(Projections.min("id"));

criteria.add(Subqueries.eq("id",dc));

still not working. sql comes out to :
select this_.TITLE_ID as TITLE1_0_0_, this_.TITLE as TITLE0_0_, this_.DATE_STRING as DATE3_0_0_
, this_.LIST_DATE as LIST4_0_0_
from top_ten_title this_ where ? =
(select min(this0__.TITLE_ID) as y0_ from top_ten_title this0__ where this0__.TITLE_ID>?)

i'm curious about the line with 'where ? = ...."

why is there a question mark there

i got it working by using
criteria.add(Subqueries.propertyEq("id",dc));
instead of
criteria.add(Subqueries.eq("id",dc));

these methods had no comments or documentation so i was clueless what the difference was. (just a remark, i never complain about a free product:)

can i give credits to myself:)

can't give credits to yourself... but reminder that I did help by getting you pointed in the right direction... ;)

you got it jt. thanks