A column of data is split and displayed in multiple rows

have a table tb, follows: id value

1 aa,bb

2 aaa,bbb,ccc

Split the value column by id, and the results are as follows:

id value

1 aa

1 bb

2 aaa

2 bbb

2 ccc

create table tb(id int,value varchar(30))

insert into tb values(1,'aa,bb')

insert into tb values(2,'aaa,bbb,ccc')

thanks!

sa-12

asked 16 Apr '19, 07:51

mfkpie8
238●64●68●72
accept rate: 12%

What have you tried so far?

(16 Apr '19, 07:58) Justin Willey

Replies hidden

Oops, I overlooked that important comment:(

(16 Apr '19, 08:09) Volker Barth

flat view

One Answer:

1	I'm not sure I understand your question but I guess you are asking for select tb.id, sp.row_value from tb cross apply sa_split_list(tb.value, ',') sp order by 1, 2 permanent link answered 16 Apr '19, 08:07 Volker Barth 39.3k●355●539●809 accept rate: 33% flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

sa-12 ×438

question asked: 16 Apr '19, 07:51

question was seen: 819 times

last updated: 16 Apr '19, 08:09

SAP SQL Anywhere