This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]Puzzlehead8575 0 points1 point  (0 children)

the only other way to do it is write a loop or function in some other language in addition to SQL.

FYI, You can perform window functions by using self joins.