Using ROW_NUMBER() to paginate your data with SQL Server 2005 and asp.net c#


SELECT TOP 20 * FROM
(
SELECT zip,city,state,latitude,longitude,timezone,dst,
ROW_NUMBER() OVER (ORDER BY zip) AS num
FROM dbo.zipcode
) AS a
WHERE num > 0

We found about 43191 records, now viewing 1 through 20.
<< prev | next >>

zipcitystatelatitudelongitudetimezonedstnumzipcitystatelatitudelongitudetimezonedstnum
00210PortsmouthNH43.005895-71.013202-51100210PortsmouthNH43.005895-71.013202-511
00211PortsmouthNH43.005895-71.013202-51200211PortsmouthNH43.005895-71.013202-512
00212PortsmouthNH43.005895-71.013202-51300212PortsmouthNH43.005895-71.013202-513
00213PortsmouthNH43.005895-71.013202-51400213PortsmouthNH43.005895-71.013202-514
00214PortsmouthNH43.005895-71.013202-51500214PortsmouthNH43.005895-71.013202-515
00215PortsmouthNH43.005895-71.013202-51600215PortsmouthNH43.005895-71.013202-516
00501HoltsvilleNY40.922326-72.637078-51700501HoltsvilleNY40.922326-72.637078-517
00544HoltsvilleNY40.922326-72.637078-51800544HoltsvilleNY40.922326-72.637078-518
00601AdjuntasPR18.180103-66.74947-40900601AdjuntasPR18.180103-66.74947-409
00602AguadaPR18.363285-67.18024-401000602AguadaPR18.363285-67.18024-4010
00603AguadillaPR18.448619-67.13422-401100603AguadillaPR18.448619-67.13422-4011
00604AguadillaPR18.498987-67.13699-401200604AguadillaPR18.498987-67.13699-4012
00605AguadillaPR18.465162-67.141486-401300605AguadillaPR18.465162-67.141486-4013
00606MaricaoPR18.182151-66.9588-401400606MaricaoPR18.182151-66.9588-4014
00607Aguas BuenasPR18.256995-66.104657-401500607Aguas BuenasPR18.256995-66.104657-4015
00609AibonitoPR18.142002-66.273278-401600609AibonitoPR18.142002-66.273278-4016
00610AnascoPR18.288319-67.13604-401700610AnascoPR18.288319-67.13604-4017
00611AngelesPR18.279531-66.80217-401800611AngelesPR18.279531-66.80217-4018
00612AreciboPR18.449732-66.69879-401900612AreciboPR18.449732-66.69879-4019
00613AreciboPR18.458093-66.732732-402000613AreciboPR18.458093-66.732732-4020

We found about 43191 records, now viewing 1 through 20.
<< prev | next >>

A Programmers Journal | rss