I don't think it's an ANSI SQL thing. I'd guess it's used to return the value of [column_name] in the last record (which in this case, is not well defined as there's no ORDER BY)
So you can achieve that by supplying an ORDER, and then limiting to fetch a single row (SetMaxResults(1)) On Sat, Nov 1, 2008 at 8:45 AM, Ayende Rahien <[EMAIL PROTECTED]> wrote: > What is Last ? > > > On Sat, Nov 1, 2008 at 8:32 AM, Nathan Stott <[EMAIL PROTECTED]> wrote: > >> >> Is there an equivalent to the SQL Last() in NHibernate criteria or HQL? >> >> As in SELECT LAST(column_name) FROM table_name >> >> >> > > > > -- Ken Egozi. http://www.kenegozi.com/blog http://www.musicglue.com http://www.castleproject.org http://www.gotfriends.co.il --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
