Select records having max value in column using NHibernate QueryOver

Question

Can I do this using QueryOver in NHibernate?

   SELECT *
   FROM TABLE_X T1
   WHERE T1.COL1 = (SELECT MAX(COL1) FROM TABLE_X T2 WHERE T1.NAME = T2.NAME)

score 0 · Accepted Answer · edited May 23 '17 at 12:13

0

Check out these questions to solve your problem:

edited May 23 '17 at 12:13

Community

answered Jul 04 '11 at 07:41

Mark Perry

1 Answers1