Guys, I need your help... How Can I perform this query using ICriteria or HQL. I am using Nhibernate 2.0. And How to perform subquery.
select * from dautotimesetting_idep d where D.BRSHLIFECOUNT in ((select max(D.BRSHLIFECOUNT) from dautotimesetting_idep d), (select max(D.BRSHLIFECOUNT) - 1 from dautotimesetting_idep d)) thanks, silent dk -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhus...@googlegroups.com. To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.