I can live without the group by, but how do I set a top 1 ? I'm using v1.2.1.4000. - I see that there is a setMaxResults in the trunk - is there no way in v1.2.1.4000 to do this ?
On Mar 10, 11:19 am, sirrocco <[email protected]> wrote: > SELECT * FROM ProductRenameHistory this_ > WHERE this_.HistoryKey = > (SELECT Top 1 this_0_.HistoryKey as y0_ > FROM ProductRenameHistory this_0_ > WHERE this_0_.WasRolledback = 0 > GROUP BY this_0_.HistoryKey , this_0_.RecordStamp > ORDER BY this_0_.RecordStamp desc) > > The above query is what I'm trying to accomplish. This is what I have. > How do I put a top 1 in there. And, how do I select only the > HistoryKey ?(and not RecordStamp too). > > DetachedCriteria lastRename = DetachedCriteria.For(typeof > (DetachedCriteria)); > lastRename.Add(Expression.Eq("WasRolledback", false)); > lastRename.AddOrder(Order.Desc("RecordStamp")); > lastRename.SetProjection(Projections.ProjectionList() > .Add(Projections.GroupProperty > ("HistoryKey")) > .Add(Projections.GroupProperty > ("RecordStamp")) > ); --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
