每种类型只查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;

查询结果：