Get multiple column data in one single column

1.00/5 (2 votes)

See more:

i want to get ID of all rows (in a single column) on which aggregate function is applied.

for example

select sum(colData), IDofAllRows from table1

Posted 23-Dec-15 12:18pm

Asim Ghazanfar

Updated 23-Dec-15 12:19pm

Add a Solution

Comments

CHill60 23-Dec-15 18:54pm

Some sample data and your expected results would help us to help you. Use the "Improve question" link to add detail

jgakenhe 23-Dec-15 20:12pm

So you want to aggregate results into 1 row. Oracle makes it easy, but SQL Server is not so easy. I am not sure what DBMS you're using, but the examples below should help.

Oracle: LISTAGG
https://oracle-base.com/articles/misc/string-aggregation-techniques

SQL Server: No function I'm aware of, here's some technigues
http://www.codeproject.com/Articles/691102/String-Aggregation-in-the-World-of-SQL-Server
https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

cmarcotte	19
OriginalGriff	10
Pete O'Hanlon	10
Rajesh Anuhya	5
SG Tamilan	-14

Pete O'Hanlon	995
OriginalGriff	930
Richard Deeming	735
merano99	355
Dave Kreskowiak	310