Desktop productivity for business analysts and programmers

generating id number

Reply
N/A
Posts: 0

generating id number

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

Thanks!
Super Contributor
Posts: 260

Re: generating id number

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.
Ask a Question
Discussion stats
  • 1 reply
  • 98 views
  • 0 likes
  • 2 in conversation