求linq查询语句，急

[NormanZL]

表a
-------------------
id money
3 20
3 20
2 30
8 10
5 50



按照id分组，按照sum（money） desc排序，
想得到一张表b为
-------------------------
id monye
5 50
3 20
3 20
2 30
8 10

[jiangshun]

            List<tab> _list = new List<tab>();
            _list.Add(new tab() { id = 3, money = 20 });
            _list.Add(new tab() { id = 3, money = 20 });
            _list.Add(new tab() { id = 2, money = 30 });
            _list.Add(new tab() { id = 8, money = 10 });
            _list.Add(new tab() { id = 5, money = 50 });

            var query = _list.OrderByDescending(m => _list.Where(n => n.id == m.id).Sum(n => n.money)).Select(m => m);

            query.ToList().ForEach(l => Console.WriteLine("id={0}     money={1}", l.id, l.money));



    public class tab
    {
        public int id { get; set; }
        public int money { get; set; }
    }

[jiangshun]

            //var query = _list.OrderByDescending(m => _list.Where(n => n.id == m.id).Sum(n => n.money)).Select(m => m);
            var query = from l in _list
                        orderby _list.Where(m => m.id == l.id).Sum(m => m.money) descending
                        select l;
            query.ToList().ForEach(l => Console.WriteLine("id={0}     money={1}", l.id, l.money));

[walj3470055]

按ID分组得到的表b为什么ID还有重复的。。

[claymore1114]

  var Query=from a from db.AA
                      group a by a.id into g
                      select new b{ id=g.Key,money=g.sum(s=>s.money)}

[q107770540]

表b 你这是按照 money desc排序的吧..

var query = from a in TabelA
            group a by a.id into b
            orderby a.money descending
            select new            
            {
                id=b.Key,
                money=b.Sum(c=.c.money)
            };

[NormanZL]

我是想按照id分组，每个组的money总和排序，所以是
50
20+20
30
10

[q107770540]

var query = from a in TabelA
            group a by a.id into b
            orderby b.Sum(c=.c.money) descending
            select new            
            {
                id=b.Key,
                money=b.Sum(c=.c.money)
            };

[NormanZL]

我要分开而不是这种表
------------
5 50
3 40
2 30
8 10


我要的是这种表
-------------
5 50
3 20
3 20
2 30
8 10


我已用sql语句写了，linq语句怎么写？