Manny Ezeagwula

Updated July 16, 2019 17:27

How to generate a sequence number in Cloud 9QL?

Follow

• Official comment

  

  Manny Ezeagwula July 16, 2019 17:32 (Edited July 16, 2019 17:32)

  You can use the `accumulate` C9QL function to do that. 

  For example, if your query returns 3 columns: country, state, city

  you can do the following operation:

  select country, state, city, 1 as sequence_key;

  select accumulate(sequence_key), country, state, city;

  Here's a recording to walk through it:  https://recordit.co/XgdPdnycGj

  Comment actions Permalink

Please sign in to leave a comment.