Title / Description
Code DECLARE @Skip int DECLARE @Take int SET @Skip = 0 -- The number of records to skip SET @Take = 10 -- The number of records to return SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [t0].[ID], [t0].[Name], [t0].[Address]) AS [ROW_NUMBER], [t0].ID, [t0].Name, [t0].Address FROM [Company] AS [t0] ) AS [t1] WHERE [t1].[ROW_NUMBER] BETWEEN @Skip + 1 AND @Skip + @Take ORDER BY [t1].[ROW_NUMBER]
Author
Highlight as C C++ CSS Clojure Delphi ERb Groovy (beta) HAML HTML JSON Java JavaScript PHP Plain text Python Ruby SQL XML YAML diff code