Monday 15 August 2011

Oracle SQL put values of a column in one row -


I have a query returning 3 columns

  ID number 123 123A 124 2b 123 1c 123 1D   

What I want to do is line it in

  ID number 123 1A, C, D < / Code>  

When I have the ID and NUMBER columns the same, there is a value and

In Oracle 11G, you can use the function:

  select ID, number, list within the group (letter, ',') ( ID as the letter from the ED, number), number Apakatebl group;   

View

No comments:

Post a Comment