| MAIN_WELL_ID | OFFSET_WELL_ID | IS_STATISTIC | RN |
| hdHqoAGZJE | 5HNVMoTjaj | 1 | 1 |
| lT5W9YGIiY | 70oGFwST66 | 1 | 1 |
| VggDGbtyhC | 7VAqMkoQRG | 1 | 1 |
| VggDGbtyhC | 7aaGqu7W1D | 0 | 1 |
| ngozuGAPrB | A6eVYovTeS | 1 | 1 |
| 9EQvWurf8A | BH2C1q2KCy | 0 | 1 |
| ngozuGAPrB | BVBMlo7ZQ3 | 1 | 1 |
| hdHqoAGZJE | Em8SEXIgOD | 0 | 1 |
| CAp8Et88aG | FIL3hwZrBO | 0 | 1 |
| VggDGbtyhC | FIL3hwZrBO | 0 | 2 |
| hdHqoAGZJE | FIL3hwZrBO | 0 | 3 |
| lT5W9YGIiY | FWMZsPy0E1 | 0 | 1 |
| ngozuGAPrB | GjSt7imGhF | 1 | 1 |
| ngozuGAPrB | IrPm4NnB45 | 0 | 1 |
| VggDGbtyhC | WtWTTsHUwu | 1 | 1 |
| CAp8Et88aG | cuCCmU3PkU | 1 | 1 |
| CAp8Et88aG | fY1qX43fM6 | 1 | 1 |
| VggDGbtyhC | g5GMiWZt50 | 1 | 1 |
| VggDGbtyhC | hdQJQY2KO6 | 1 | 1 |
| CAp8Et88aG | mo5Ce98ceA | 1 | 1 |
| hdHqoAGZJE | zd4epRqjDp | 1 | 1 |
| 9EQvWurf8A | zd4epRqjDp | 0 | 2 |
| CAp8Et88aG | zd4epRqjDp | 0 | 3 |
运行sql
select * from (select main_well_id,offset_well_id,is_statistic, rank()over(partition by offset_well_id order by is_statistic desc,main_well_id ) rn from aaa )a where rn=1
运行结果
| MAIN_WELL_ID | OFFSET_WELL_ID | IS_STATISTIC | RN |
| hdHqoAGZJE | 5HNVMoTjaj | 1 | 1 |
| lT5W9YGIiY | 70oGFwST66 | 1 | 1 |
| VggDGbtyhC | 7VAqMkoQRG | 1 | 1 |
| VggDGbtyhC | 7aaGqu7W1D | 0 | 1 |
| ngozuGAPrB | A6eVYovTeS | 1 | 1 |
| 9EQvWurf8A | BH2C1q2KCy | 0 | 1 |
| ngozuGAPrB | BVBMlo7ZQ3 | 1 | 1 |
| hdHqoAGZJE | Em8SEXIgOD | 0 | 1 |
| CAp8Et88aG | FIL3hwZrBO | 0 | 1 |
| lT5W9YGIiY | FWMZsPy0E1 | 0 | 1 |
| ngozuGAPrB | GjSt7imGhF | 1 | 1 |
| ngozuGAPrB | IrPm4NnB45 | 0 | 1 |
| VggDGbtyhC | WtWTTsHUwu | 1 | 1 |
| CAp8Et88aG | cuCCmU3PkU | 1 | 1 |
| CAp8Et88aG | fY1qX43fM6 | 1 | 1 |
| VggDGbtyhC | g5GMiWZt50 | 1 | 1 |
| VggDGbtyhC | hdQJQY2KO6 | 1 | 1 |
| CAp8Et88aG | mo5Ce98ceA | 1 | 1 |
| hdHqoAGZJE | zd4epRqjDp | 1 | 1 |
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27121964/viewspace-741605/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/27121964/viewspace-741605/
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
