Please help.
In my database there is a field called round.

1
3
10
15
16
21
...
Now I want to now how many rounds are between the next.
How can I do this in SQL?

TIA
Dieter

This question has been answered several times in this group, if you can't
find it post again and I'll give it a try.

Robert

"Dieter Nagy" <dieter.nag@tele2.at> wrote in message
news:ED56E0B1-FE6E-48E5-A7A0-B2F3BADBC60B@news.elevatesoft.com...
> Please help.
> In my database there is a field called round.
>
> 1
> 3
> 10
> 15
> 16
> 21
> ..
> Now I want to now how many rounds are between the next.
> How can I do this in SQL?
>
> TIA
> Dieter
>

Thanks I found it.

Dieter