select *
from (photo_asset_stake a
left join photo_asset_station b on a.STATION_UUID = b.UUID)
where STAKE_NO is not null
group by STATION_NO
having STATION_NO > 3000026004413947667
order by STATION_NO asc
limit 50
执行顺序:from - where - group by - having - select - order by - limit
from 表别名优先级最高适用于全局
select 字段别名优先级较低适用于只能用于order by
where和having区别
where 是分组之前进行过滤,不满足where条件,不参与分组;having是分组之后对结果进行过滤where 不能对聚合函数进行判断,而having可以。
where > 聚合函数 > having
数据库三种类型:数值,字符串,日期时间