2013年12月26日
Nhibernate Case SUM
摘要： SELECT IDSUM(CASE WHEN myProperty = 2 THEN 1 ELSE 0 END) as nbRowWithValueOf2,SUM(CASE WHEN myProperty = 3 THEN 1 ELSE 0 END) as nbRowWithValueOf3FROM FooGROUP BY IDqueryover = queryover .Select( Projections.Group(c => c.ID), Projections.Sum( Projections.Conditional( ... 阅读全文
posted @ 2013-12-26 16:36 ido 阅读(352) 评论(0) 推荐(0) 编辑