select min(hm), sum(sl), id from ( ;
select hm, sl, ;
(2^(asc(left(hm,1))-47)+2^(asc(substr(hm,2,1))-47)+2^(asc(substr(hm,3,1))-47))*;
asc(left(hm,1))*asc(substr(hm,2,1))*asc(substr(hm,3,1)) as id ;
from tt) as tmp ;
group by id order by 1 into cursor result
[/Quote]
select min(hm), sum(sl), id from ( ;
select hm, sl, ;
(2^(asc(left(hm,1))-47)+2^(asc(substr(hm,2,1))-47)+2^(asc(substr(hm,3,1))-47))*;
asc(left(hm,1))*asc(substr(hm,2,1))*asc(substr(hm,3,1)) as id ;
from tt) as tmp ;
group by id order by 1 into cursor result
select min(号码), sum(数量) from ( ;
select 号码, 数量, ;
2^(asc(left(号码,1)))+2^(asc(substr(号码,2,1)))+2^(asc(substr(号码,3,1))) as id ;
from tt) as tmp ;
group by id order by 1
源数据太多,要转成测试源需要点耐心,最好直接贴成 create cursor ... 和 insert into ... 这样,直接复制过来就可以测试了。
select min(号码), sum(数量) from ( ;
select 号码, 数量, ;
2^(asc(left(号码,1)))+2^(asc(substr(号码,2,1)))+2^(asc(substr(号码,3,1))) as id ;
from tt) as tmp ;
group by id order by 1
源数据太多,要转成测试源需要点耐心,最好直接贴成 create cursor ... 和 insert into ... 这样,直接复制过来就可以测试了。