è¿ä¸ªä¸è½ç¨è§å¾å®æï¼å 为è§å¾æ¯åºæ¬åºå®çç»æï¼åºè¯¥ç¨åå¨è¿ç¨ï¼ç½ä¸æä¸ä¸è¡å转æ¢åå¨è¿ç¨å¦å¤ï¼æ°æ®é½æ¯å¨ç¨åºä¸ä½¿ç¨ï¼å¨ç¨åºä¸å代ç åèæ´æ¹ä¾¿ï¼æ¯åå¨è¿ç¨è¿å¥½ç¨ï¼å¿«ï¼æ¹ä¾¿ ãå¦æä½ ç¡¬è¦ä¸ä¸ªè§å¾ï¼æè¯åä¸ä¸æ tbæ¹æä½ ç表åå§ãselect id ,(select name from tb where id = x.id and name ='a') as namea,(select name from tb where id = x.id and name ='b') as nameb,(select name from tb where id = x.id and name ='c') as namec,from tb x group by id
温馨提示:内容为网友见解,仅供参考