oracle的函数转成mysql
create or replace view view_sys_xyzy as
select distinct(FIRST_VALUE(zymc||'['||zybm||']')OVER(PARTITION BY zybm,bmbh ORDER BY zymc)) zymcbm,zybm,bmbh
--from zc_sjtb_zybm order by bmbh,zybm;
from sys_zybm order by bmbh,zybm
;
我要怎么把上述的sql语句 转换成mysql 谢谢 这是我的处女贴