select name , case when sum(tele)>=3 then 3 else sum(tele) end tele from t1 group by name
楼上写的是sql语句吗?有点看不懂啊
表b(欄位a,b) select * from (select rownum as id,a,b from b) a where id in ( select min(rownum) as a from b group by a union select min(rownum)+1 from b group by a union select min(rownum)+2 from b group by a);
from t1 group by name
select * from (select rownum as id,a,b from b) a where id in ( select min(rownum) as a from b group by a union select min(rownum)+1 from b group by a union select min(rownum)+2 from b group by a);