The create or replace the view view_sys_xyzy as
Select distinct (FIRST_VALUE (zymc | | '[' | | zybm | |'] ') OVER (PARTITION BY zybm, BMBH ORDER BY zymc)) zymcbm, zybm, BMBH
- the from zc_sjtb_zybm order by BMBH zybm;
The from sys_zybm order by BMBH, zybm
;

How do I convert the above SQL statement to mysql thank you this is my virgin stick