SELECT code,sno
from synch.hip_org ho
group by code order by sno 希望像mysql一样,select 里面的列,order by 里面的列不一定要在分组列中,
参照mysql 改了sql_mode 参数,改了还是不得行。
sql_mode 参数如下:
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'