Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lcpx
Yak Posting Veteran
54 Posts |
 Posted - 2005-12-05 : 06:07:28
|
| how to combine multiple rows to one.table:ID Name Value1 xx 101 xx 201 xx 152 oo 102 oo 122 oo 8How can I use SQL to get the result like below:1 xx 10,20,152 oo 10,12,8thanks very much for your help!I am using Oracle by the way. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 06:11:58
|
| http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=trueMadhivananFailing to plan is Planning to fail |
 |
|
|
lcpx
Yak Posting Veteran
54 Posts |
Posted - 2005-12-05 : 06:15:48
|
| Thanks for your response, but what I want is one sql query. I don't want to PL/SQL involved in. Cheers! |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 06:21:07
|
quote:
Originally posted by lcpx
Thanks for your response, but what I want is one sql query. I don't want to PL/SQL involved in. Cheers!
No. You should use Function that is called in your Select statementRead that article fullyMadhivananFailing to plan is Planning to fail |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-05 : 08:00:26
|
quote:
I don't want to PL/SQL involved in
this is a Microsoft SQL Server forums. Only T-SQL here no PL/SQL -----------------[KH] |
|
|
|
|
|
|
How to combine multiple rows to one?