Re: [sqlite] creating a summary table

2013-02-19 Thread Paul Sanderson
That did the job - Thank You On 18 February 2013 18:15, James K. Lowden wrote: > On Mon, 18 Feb 2013 17:02:53 + > Paul Sanderson wrote: > > > nc > > 1a > > 2a > > 3a > > 4b > > 5b > > 3b > > 4b > > 2b > > 3a > > 5b > > 2b > > > > > > I have a

Re: [sqlite] creating a summary table

2013-02-18 Thread 雷钦
On 2013-02-18 17:02:53 +, Paul Sanderson wrote: > nc > 1a > 2a > 3a > 4b > 5b > 3b > 4b > 2b > 3a > 5b > 2b > > > I have a table as above > > I want to create a summary table that shows in the first column the total > number of occurrences of a

Re: [sqlite] creating a summary table

2013-02-18 Thread James K. Lowden
On Mon, 18 Feb 2013 17:02:53 + Paul Sanderson wrote: > nc > 1a > 2a > 3a > 4b > 5b > 3b > 4b > 2b > 3a > 5b > 2b > > > I have a table as above > > I want to create a summary table that shows in the first column the > total number of occurrenc

[sqlite] creating a summary table

2013-02-18 Thread Paul Sanderson
nc 1a 2a 3a 4b 5b 3b 4b 2b 3a 5b 2b I have a table as above I want to create a summary table that shows in the first column the total number of occurrences of a value in the first column (n) and in the second column for each value in n a count of t