select a1,sum(b1) as c1 from tablename where a1 like 't%' and 日期>=前100天 group by a1 是这样子吗?
还是 select a1,sum(b1) as c1 from tablename where 日期>=前100天 group by a1 having a1 like 't%'? 或者 select a1,sum(b1) as c1 from tablename group by a1 having a1 like 't%' and 日期>前100天?或者 select a1,sum(b1) as c1 from tablename where a1 like 't%' group by a1 having 日期>前100天 ?
我用 select a1,sum(b1) as c1 from tablename where a1 like 't%' group by a1 having rumnum>100 order by rq desc 出错,提示not a not a GROUP BY expression
敲错了:select a1,sum(b1) as c1 from tablename where a1 like 't%' group by a1 having rownum>100 order by rq desc
是这样子吗?
select a1,sum(b1) as c1 from tablename where 日期>=前100天 group by a1 having a1 like 't%'?
或者
select a1,sum(b1) as c1 from tablename group by a1 having a1 like 't%' and 日期>前100天?或者
select a1,sum(b1) as c1 from tablename where a1 like 't%' group by a1 having 日期>前100天
?
select a1,sum(b1) as c1 from tablename where a1 like 't%' group by a1 having rumnum>100 order by rq desc
出错,提示not a not a GROUP BY expression