How to output multi data per column in one row?

Question

I have data as follows: We call this table Client_benefits

Client_name, Income_type, Frequency
Joe Smith SSI Month
Joe Smith Work Week

I would like an out put row as follows: I would like something like

Select Client_name, Income_type, Frequency from Client_benefits

Do I use grouo_by?

To create the singular per client output I need?

Joe Smith SSI Month Work Week

Rather than currently I am getting duplicates but would like to see one row if possible.

What's the exact expected result according to your sample data? — The Impaler, Dec 22 '20 at 19:01
Does this answer your question? [SQL Query to concatenate column values from multiple rows in Oracle](https://stackoverflow.com/questions/4686543/sql-query-to-concatenate-column-values-from-multiple-rows-in-oracle) — JonathanDavidArndt, Dec 22 '20 at 19:15
Which DBMS product are you using? "SQL" is just a query language, not the name of a specific database product. Please add a [tag](https://stackoverflow.com/help/tagging) for the database product you are using. [Why should I tag my DBMS](https://meta.stackoverflow.com/questions/388759/) — a_horse_with_no_name, Dec 22 '20 at 23:35

score 0 · Answer 1 · answered Dec 22 '20 at 19:15

0

I've seen this before. You want output similar to:

Joe Smith "SSI Month" "Work Week"

It is doubtful that you will be able to segregate these into their own columns, but you can concatenate them into a single field.

That question has already been asked and answered here:

SQL Query to concatenate column values from multiple rows in Oracle

answered Dec 22 '20 at 19:15

JonathanDavidArndt

2,245
13
33
46

that's an Oracle syntax so I am not sure about this. Usually there is syntax differences to the extent you cannot rely on using Oracle code in a SQL Server. – Voice Sober Dec 22 '20 at 19:25

score 0 · Answer 2 · answered Dec 22 '20 at 21:27

0

You can write the query as:

 SELECT Client_name+ ' ' +  
    STUFF((SELECT ', ' + Income_type + ' ' + Frequency
           FROM Client_benefits CBIn 
           WHERE CBIn.Client_name = CBOut.Client_name 
          FOR XML PATH('')), 1, 2, '')
FROM Client_benefits CBOut
GROUP BY Client_name

SQL Demo here..

answered Dec 22 '20 at 21:27

Deepshikha

9,358
2
18
20

HI this idea means entry to a table. I am looking for a dynamic query. – Voice Sober Dec 23 '20 at 00:07

How to output multi data per column in one row?

2 Answers2