Skip to content

Instantly share code, notes, and snippets.

@shaneis
Created April 19, 2018 11:15
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
Where clause with windows function that will not work
SELECT DummyId,
PartitionId,
ROW_NUMBER() OVER (PARTITION BY PartitionId ORDER BY DummyId DESC) AS LastN
FROM dbo.DummyTable
WHERE ROW_NUMBER() OVER (PARTITION BY PartitionId ORDER BY DummyId DESC) <= 2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment