Home
Sign Up
Sign In
V2EX
›
问与答
求解一道SQL题:
hanxiaowu
·
Jun 14, 2013
· 3004 views
This topic created in 4778 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
·
979 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 33ms ·
UTC 19:51
·
PVG 03:51
·
LAX 12:51
·
JFK 15:51
♥ Do have faith in what you're doing.
❯