Re: [sqlite] SQL query assistance...

2007-07-02 Thread Jeff Godfrey
- Original Message - From: "Dan Kennedy" <[EMAIL PROTECTED]> To: 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 sample data... I

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 the

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Jeff Godfrey" <[EMAIL PROTECTED]> Thanks Gerry, Indeed, I have tried exactly that. Hmmm... This seems to be a thread for eating crow... ;^) Hi Gerry, My actual query is a bit more complex than the sample I posted. I thought my posted sample was a valid

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Andrew Finkenstadt" <[EMAIL PROTECTED]> To: 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 following sample data

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Andrew Finkenstadt" <[EMAIL PROTECTED]> To: 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 following sample data

Re: [sqlite] SQL query assistance...

2007-07-01 Thread Jeff Godfrey
- Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: 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 Version --- - --- 1 name1 0.9

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 f

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 r