generating id number

[deleted_user]

Hi,
How do I do to automatically generate a unique id number, with condition, to my data set???

Thanks!

[Olivier]

Hello.

You could use the MONOTONIC() function in a query. This undocumented SQL feature allows you to add a sequential number (1 on first row, 2 on second, 3 and so on). If you have conditions in a WHERE statement, the numered rows are only the selected ones.

I hope it solves your problem.