What are the challenges you face when working across database platforms? Take the survey
Options

rownum

Bill_RossBill_Ross Posts: 20
edited May 13, 2010 9:16AM in SQL Prompt code snippets
I love the Over Partition:

row_number() OVER ( Partition BY <foreignkey, varchar> order by <foreignkey,varchar> ) AS [Seq]

Ctrl-Shit-M to populate
Sign In or Register to comment.