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
-~----------~----~----~----~------~----~------~--~---
