描述:根据顾客的国家分组,查询顾客数大于5的国家名和顾客数
查询句法:var 一般分组 = from c in ctx.Customersgroup c by c.Country into gwhere g.Count() > 5orderby g.Count() descendingselect new{ 国家 = g.Key,顾客数 = g.Count()};对应SQL:SELECT [t1].[Country], [t1].[value3] AS [顾客数]FROM (SELECT COUNT(*) AS [value], COUNT(*) AS [value2], COUNT(*) AS [value3], [t0].[Country]FROM [dbo].[Customers] AS [t0]GROUP BY [t0].[Country]) AS [t1]WHERE [t1].[value] > @p0ORDER BY [t1].[value2] DESC-- @p0: Input Int32 (Size = 0; Prec = 0; Scale = 0) [5]描述:根据国家和城市分组,查询顾客覆盖的国家和城市
查询句法:var 匿名类型分组 = from c in ctx.Customersgroup c by new { c.City, c.Country } into gorderby g.Key.Country, g.Key.Cityselect new{ 国家 = g.Key.Country,城市 = g.Key.City};描述:按照是否超重条件分组,分别查询订单数量查询句法:var 按照条件分组 = from o in ctx.Ordersgroup o by new { 条件 = o.Freight > 100 } into gselect new{ 数量 = g.Count(),是否超重 = g.Key.条件 ? "是" : "否"};