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 謝謝 這是我的處女貼
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/102093.html
標籤:開發
