Pagination SQL row_number

HTML

SELECT *
FROM (
SELECT top 100 row_number() OVER (ORDER BY tblState.stateid DESC) AS resultNum, count(tblState.stateid) OVER () AS row_total, tblState.StateID
FROM tblState 
) AS numberResults
WHERE resultNum BETWEEN 21 AND 31

Join the 4+ million users, and keep the JSFiddle dream alive.

Ad-free

All ads in the editor and listing pages are turned completely off.
Use pre-released features

You get to try and use features (like the Palette Color Generator) months before everyone else.
Fiddle collections

Sort and categorize your Fiddles into multiple collections.
Private collections and fiddles

You can make as many Private Fiddles, and Private Collections as you wish!
Console

Debug your Fiddle with a minimal built-in JavaScript console.

Pagination SQL row_number

HTML

Please Whitelist JSFiddle in your content blocker.

Join the 4+ million users, and keep the JSFiddle dream alive.

Ad-free

Use pre-released features

Fiddle collections

Private collections and fiddles

Console