Dynamic sequencing with a single query

(Shlomi Noach) It is a known trick to use a session variables for dynamically counting/sequencing rows. The way to go is to SET a variable to zero, then use arithmetic within assignment to increment its value for each row in the SELECTed rows.

Read More - Register for Free Membership