[sqlite] MIN/MAX query

[Clemens Ladisch]

David Bicking wrote:
> I have a table
> I  L  V
> 1 1   A
> 1 2   A
> 1 3   A
> 1 4   B
> 1 5   B
> 1 6   A
> 1 7   A
> 2 1   C
> 2 2   C
> I want to return the minimal and maximum L for each "group" of V in a given I.
>
> The result I want:
> I  MinL  MaxL  V
> 1  1        3           A
> 1  4        5           B
> 1  6        7           A
> 2  1        2           C

Define "group".  Please note that SQL tables are unordered.
Are groups defined by the order of the L values?


Regards,
Clemens