Hello,

I wish to display the ID (of all time points = 0). I can handle this programatically but rather would do in SQL.

The following query returns the time points

SELECT ID as VAL
FROM x
WHERE "TIME" = 0
order by id

The values are
87
117
120

Now, is there a function in FB that will return me an ID (sequential, starting at 1 and increments of 1) for each of the records like so?

ID VAL
1 87
2 117
3 120

Thanks in advance,
Ronan

[Non-text portions of this message have been removed]