rownum

Share your SQL code snippets for SQL Prompt!

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

rownum

Postby Bill_Ross » Thu May 13, 2010 2:16 pm

I love the Over Partition:

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

Ctrl-Shit-M to populate
Bill_Ross
 
Posts: 14
Joined: Mon Mar 22, 2010 6:49 pm

Return to SQL Prompt code snippets

Who is online

Users browsing this forum: No registered users and 0 guests