7,714
社区成员
发帖
与我相关
我的任务
分享
select a.aa,a.bb,min(b.aa) as naa, min(b.bb) as nbb,
a.aa+(naa-a.aa)/5*1 as x1,a.bb+(nbb-a.bb)/5*1 as y1,
a.aa+(naa-a.aa)/5*2 as x2,a.bb+(nbb-a.bb)/5*2 as y2,
a.aa+(naa-a.aa)/5*3 as x3,a.bb+(nbb-a.bb)/5*3 as y3,
a.aa+(naa-a.aa)/5*4 as x4,a.bb+(nbb-a.bb)/5*4 as y4
from tt a ,tt b
where a.aa<b.aa
group by a.aa,a.bb
aa |bb |naa|nbb |x1 |y1 |x2 |y2 |x3 |y3 |x4 |y4 |
25 |15000|26 |15400|25.2|15080 |25.4 |15160|25.6|15240|25.8|15320|
26 |15800|27 |15400|26.2|15720 |26.4 |15640|26.6|15560|26.8|15480|