Need help to write this sql query as a DetachedCriteria. Could anyone please help? Thanks!
SELECT TOP 5 oi.SKU, sum(oi.Quantity * oi.Price) total FROM OrderItem oi GROUP BY oi.SKU ORDER BY total DESC --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
