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