Skip to content

Instantly share code, notes, and snippets.

@ebryn

ebryn/gist:309827

Created February 20, 2010 18:53
Show Gist options
  • Save ebryn/309827 to your computer and use it in GitHub Desktop.
Save ebryn/309827 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
SELECT TOP 4 * FROM (
SELECT TOP 4 * FROM (
SELECT TOP 8 [users].[id], [users].[name]
FROM [users]
ORDER BY [users].[id] ASC) AS tmp1
ORDER BY [tmp1].[id] DESC) AS tmp2
ORDER BY [tmp2].[id] ASC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment