Re: [sqlite] Pivot table from multiple columns

Cool, thank you! This works perfect... Now I have to disect it and figure this syntax out more... Thanks to all for the education! -Joe On Wed, Feb 16, 2011 at 5:15 PM, Simon Davies wrote: > On 16 February 2011 23:00, Joe Bennett wrote: >

Re: [sqlite] Pivot table from multiple columns

On 16 February 2011 23:00, Joe Bennett wrote: > OK, this looks like it concatenated Column_1 and Column_2 and returns the > count of the new unique concatenated pair? What I am looking for (and I > apologize for not being clear) is a list of the unique values (Column > 1

Re: [sqlite] Pivot table from multiple columns

OK, this looks like it concatenated Column_1 and Column_2 and returns the count of the new unique concatenated pair? What I am looking for (and I apologize for not being clear) is a list of the unique values (Column 1 and 2 appended) and their count... I'll try to demonstrate the expected example

[sqlite] Pivot table from multiple columns

Hi all, I am trying to locate any examples (if possible) that can clue me in on taking column a and appending column b then do a pivot/group by to get the total for each unique values... I'll try to demonstrate the base data: *Column_1* *Column_2* Value AValue C Value B