What function should I use to get a serial number, together with my results, from a query? Ex. Of output I want: 1 ooo pp ij 2 hou joo iu 3 bhi ft yh Basically, I would like to have one column with integers, from 1 onwards, no matter how many tables I join in, or the data that I get back.
first of all - this is job for client program to do the numbering, but if you really insist on having this in database (why?) then just use temporary sequence.