每种类型只查3条

业务需求：查询运单号和不可控类型两个字段。查询条件：报表日期2017-02-08、不可控类型为3,4,23,25、每种类型只查3条。

查询SQL：

SELECT WAYBILL_NO 运单号, CONTROLLABLE_TYPE 不可控类型
  FROM (SELECT T.WAYBILL_NO,
               T.CONTROLLABLE_TYPE,
               ROW_NUMBER() OVER(PARTITION BY T.CONTROLLABLE_TYPE ORDER BY T.CONTROLLABLE_TYPE) RN
          FROM TT_EXPIRED_DUTY_NEW T
         WHERE T.REPORT_DT >= DATE '2017-02-08'
           AND T.REPORT_DT < DATE '2017-02-09'
           AND T.CONTROLLABLE_TYPE IN (3, 4, 23, 25))
 WHERE RN <= 3;

查询结果：