oracle keep函数

来源：互联网发布：网络信息群发软件编辑：程序博客网时间：2024/06/07 07:07

select id,       mc,       sl,       min(mc) keep(DENSE_RANK first ORDER BY sl) over(partition by id) a1,-- sl中最小中，取mc最小       max(mc) keep(DENSE_RANK last ORDER BY sl) over(partition by id) a2,-- sl中最大中，取mc最大       min(mc) over(partition by id) a3,       max(mc) over(partition by id) a4,       min(mc) keep(DENSE_RANK first ORDER BY sl) over(partition by id) a5,-- sl中最小中，取mc最小       max(mc) keep(DENSE_RANK first ORDER BY sl) over(partition by id) a6,-- sl中最小中，取mc最大       min(mc) keep(DENSE_RANK last ORDER BY sl) over(partition by id) a7,-- sl中最大中，取mc最小       max(mc) keep(DENSE_RANK last ORDER BY sl) over(partition by id) a8-- sl中最大中，取mc最大  from testselect * from test for update

IDMCSLA1A2A3A4A5A6A7A8111113555333111666555666111333212223555333111666555666111333313333555333111666555666111333415552555333111666555666111333516662555333111666555666111333621111111333111555111555222333722222111333111555111555222333823332111333111555111555222333925551111333111555111555222333

0 0