> |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 31/05/2005 60
> |3 25
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
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
You could have a look at the OFFSET and LIMIT modifiers
as for untested example
select ((select max( "AValue") from table group by "Num") - "AValue") as
difference from table order by "AValue" desc offset 1
this says: give me a inversed ordered AValue-list but ommitting the first
(biggest) and su
