这样的一个数据的排列,
ws_mold cst_mold item_no
1 1 2
1 1 3
1 1 4
2 2 5
2 2 6
2 3 7
显示成这样的
ws_mold cst_mold item_no
1 1 2
3
4
2 2 5
6
2 3 7
方法一:
select decode(lag(ws_mold,1,null)over(partition by ws_mold order by ws_mold),null,ws_mold) ws_mold,
decode(lag(cst_mold,1,null)over(partition by ws_mold order by ws_mold),null,cst_mold) cst_mold,
item_no
from wst_tool_plan
方法二:
select DECODE(ROW_NUMBER()OVER(PARTITION BY ws_mold ORDER BY ws_mold),1,ws_mold,NULL) ws_mold,
DECODE(ROW_NUMBER()OVER(PARTITION BY ws_mold ORDER BY ws_mold),1,cst_mold,NULL) cst_mold,
item_no
from wst_tool_plan