Sqlserver——查询技巧/优化方案——根据多个字段分组,后取出分组中按多个列排序的最大值记录

          文字描述起来有点抽象，具体的先看示例，相信很多人碰到过类型的场景

                      SELECT    'A' AS ii ,
                                1 AS i1 ,
                                1 AS i2
                      UNION ALL
                      SELECT    'A' AS ii ,
                                3 AS i1 ,
                                2 AS i2
                      UNION ALL
                      SELECT    'A' AS ii ,
                                2 AS i1 ,
                                1 AS i2
                      UNION ALL
                      SELECT    'A' AS ii ,
                                2 AS i1 ,
                                1 AS i2
                      UNION ALL
                      SELECT    'B' AS ii ,
                                1 AS i1 ,
                                1 AS i2
                      UNION ALL
                      SELECT    'B' AS ii ,