Re: [SQL] How do write a query...

2005-06-10 Thread Mischa Sandberg
> |From: Alain Reymond [mailto:[EMAIL PROTECTED] > |Sent: Mittwoch, 01. Juni 2005 18:01 > |Subject: [SQL] How do write a query... > | > |I have a table like > |IdNum Date AValue > |1 10 01/01/2005 50 > |2 10

Re: [SQL] How do write a query...

2005-06-08 Thread Bruno Wolff III
Please keep replies copied to the list unless you have a specific reason not to. This will help you get help and will help other people learn from the discussion. On Wed, Jun 08, 2005 at 13:56:36 +0200, Alain <[EMAIL PROTECTED]> wrote: > > In fact, these are results of analyses. For one patient

Re: [SQL] How do write a query...

2005-06-06 Thread Bruno Wolff III
On Wed, Jun 01, 2005 at 18:00:49 +0200, Alain Reymond <[EMAIL PROTECTED]> wrote: > Hello, > > I have the following problem : > > I have a table like > IdNum Date AValue > 1 10 01/01/2005 50 > 2 10 31/05/2005 60 > 3 25

Re: [SQL] How do write a query...

2005-06-06 Thread KÖPFERL Robert
st but ommitting the first (biggest) and subtract each from the biggest value of each group |-Original Message- |From: Alain Reymond [mailto:[EMAIL PROTECTED] |Sent: Mittwoch, 01. Juni 2005 18:01 |To: pgsql-sql@postgresql.org |Subject: [SQL] How do write a query... | | |Hello, | |I have t

[SQL] How do write a query...

2005-06-05 Thread Alain Reymond
Hello, I have the following problem : I have a table like IdNum Date AValue 1 10 01/01/2005 50 2 10 31/05/2005 60 3 25 02/02/2005 55 4 25 15/03/2005 43 5 25 28/05/2005 62 etc.