select Field1,distinct Field2 from 表 order by Field2
用sql语句应该得不到那样的结果,需要对查询结果进行处理
sql语句不行,可以用存储过程
一句SQL显然是搞不定的,存储过程用游标(select Field2 from 表A group by Field2 order by Field2),然后逐条对字段Field1累加字符串就完了。
通过交叉查询,绝对可以实现,以前在CSDN有人替我解决过,不好意思,可是我忘记了
每个Field2只对应2个Field1的话好解决,否则有点难度
按楼主提供的数据这样就可以:select minf1 & maxf1 as f1, t.f2 from (select max(f1) as maxf1,f2 from tb_f group by f2) s, (select min(f1) as minf1,f2 from tb_f group by f2) t where s.f2=t.f2如果Field2对应随意个Field1,就要另想办法了
from (select max(f1) as maxf1,f2 from tb_f group by f2) s,
(select min(f1) as minf1,f2 from tb_f group by f2) t
where s.f2=t.f2如果Field2对应随意个Field1,就要另想办法了