i am trying to add numbers to a literal in a select query. I want to start at a specific number and add to it for each row. The literal is set. Now I have something like this:
"NO"1+5 as New_FacID
which i want to look like in the New_FacID field:
because I am selecting 6 records.