Home
Sign Up
Sign In
V2EX
›
问与答
求解一道SQL题:
hanxiaowu
·
Jun 14, 2013
· 2947 views
This topic created in 4736 days ago, the information mentioned may be changed or developed.
请使用SQL视图解决,根据分隔符拆分表字段。
Test表,包含两个字段Id,Value
Id Value
1 aa,bcd,ef
2 ef,cd
SQL View结果:
Id Value
1 aa
1 bcd
1 ef
2 ef
2 cd
多谢!
No Comments Yet
EF
value
SQL
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Solana
·
3222 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 26ms ·
UTC 13:29
·
PVG 21:29
·
LAX 06:29
·
JFK 09:29
♥ Do have faith in what you're doing.
❯