ä¾å¦è¡¨ä¸æ2个å段ï¼IDï¼StrVal
é£ä¹æ³è®©IDå段åæåºå®å¼,å¯ä»¥è¿æ ·åï¼
select 1 as id,StrVal from 表
è¿æ ·ï¼ææçIDå°±é½åæ1äº
---------------------------------------------
åºäºä½ çä¿®æ¹ï¼
æ¯å¦è¯´è¡¨aä¸æäºä¸ªå段ï¼å段1ï¼å段2ï¼å段3ï¼å段4ï¼å段5
åæ¥å段1çå¼å为01ï¼ç°å¨ææ³æå¡æ¯å段4å¼ä¸º3çè®°å½çå段1å¼å
¨é¨å为02æä¹å
åºè¿æ ·åï¼
select '02' å段1,å段2,å段3,å段4,å段5 from a where å段4=3
温馨提示:答案为网友推荐,仅供参考