SQL sort in join

inner join (select StartDate, row_number() over (order by StartDate desc) as rowNumber from VendItemPrice with (nolock)) vip on vi.PriceLineId = vip.PriceLineId

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.