Re: [sqlite] SQL query assistance...

2007-07-02 Thread Jeff Godfrey
- Original Message - From: "Dan Kennedy" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, July 02, 2007 4:17 AM Subject: Re: [sqlite] SQL query assistance... On Sun, 2007-07-01 at 16:31 -0500, Jeff Godfrey wrote: Hi All, Given the following sa

Re: [sqlite] SQL query assistance...

2007-07-02 Thread Dan Kennedy
On Sun, 2007-07-01 at 16:31 -0500, Jeff Godfrey wrote: > Hi All, > > Given the following sample data... > > ID Name Version > --- - --- > 1 name1 0.9 > 2 name1 1.0 > 3 name2 1.2 > 4 name3 1.0 > 5 name3 1.7 > 6 name3 1.5 > > I need to create a query that will group

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Andrew Finkenstadt" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, July 01, 2007 4:45 PM Subject: Re: [sqlite] SQL query assistance... On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote: Hi All, Given the

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, July 01, 2007 4:40 PM Subject: Re: [sqlite] SQL query assistance... Jeff Godfrey wrote: Hi All, Given the following sample data... ID Name Versi

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Andrew Finkenstadt
On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote: Hi All, Given the following sample data... ID Name Version --- - --- 1 name1 0.9 2 name1 1.0 3 name2 1.2 4 name3 1.0 5 name3 1.7 6 name3 1.5 I need to create a query that will group the data together by Name, but

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Gerry Snyder
Jeff Godfrey wrote: Hi All, Given the following sample data... ID Name Version --- - --- 1 name1 0.9 2 name1 1.0 3 name2 1.2 4 name3 1.0 5 name3 1.7 6 name3 1.5 I need to create a query that will group the data together by Name, but for each group will return the

[sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
Hi All, Given the following sample data... ID Name Version --- - --- 1 name1 0.9 2 name1 1.0 3 name2 1.2 4 name3 1.0 5 name3 1.7 6 name3 1.5 I need to create a query that will group the data together by Name, but for each group will return the record with the