使用group by查询

Question

 SELECT t1.SORDER_NO,
                 t1.a,
                 t1.b,
                 t1.c,
                 T1.d,
            FROM   表 t1
                 JOIN
                    (SELECT t2.a,
                              t2.b,
                              COUNT ( * ) repeat
                         FROM 表 t2
                         GROUP BY t2.a, t2.b) tab1
                 ON t1.b= tab1.b
                    AND t1.a= tab1.a
                    where 条件
                 order by 

Answer 1

SELECT t1.SORDER_NO, count(1)
  FROM 表 t1
  JOIN (SELECT t2.a, t2.b, COUNT(*) repeat FROM 表 t2 GROUP BY t2.a, t2.b) tab1 ON t1.b =
                                                                                  tab1.b
                                                                              AND t1.a =
                                                                                  tab1.a
 where 0 = 0
 group by t1.SORDER_NO
这是一个简单的分组