sql语句

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

数据库三种类型：数值，字符串，日期时间