MS SQL Pagination :: Code Pin Board :: Craige

JavaScript is not enabled on your browser and in order to properly use Coder Profile JavaScript is required.
To view instructions on how to enable JavaScript on your browser click here.

Craige » Code Pin Board » MS SQL Pagination

	Example Framework Implementation	286	2
	PHP (Hypertext Preprocessor)	Views	Comments

	MS SQL Pagination	365	0
	SQL (Structured Query Language)	Views	Comments

	MS SQL - MySQL for indra	416	0
	SQL (Structured Query Language)	Views	Comments

	Bitwise Boolean Inverse	419	4
	C	Views	Comments

	PHP-GTK Port Scaner	404	0
	PHP (Hypertext Preprocessor)	Views	Comments

Page 1 of 1

MS SQL Pagination

Public URL

http://www.coderprofile.com/pinned-code/219/ms-sql-pagination

Language	SQL (Structured Query Language)
Expires	Never
Length	119 Characters (8 Lines)
Password	no password

Download Source Code
Source Code

MS SQL has no LIMIT keyword, and this you must get creative with the TOP and ORDER BY keywords, using sub-queries.

Will SELECT rows 5 - 10

SELECT TOP 5 DT.*
FROM
(SELECT TOP 10 *
FROM tblEX
WHERE 1=1
ORDER BY id DESC
) DT
ORDER BY id ASC

Please login to post comments.

Craige Leeder (20)
Canada, Ontario

Craige has 5 fans
become a fan

» Applications

	Source Codes (2)
	Code Pin Board (5)

» About Me

	About Me
	Friends (17)
	Résumé

» Misc

Overview

Send A Friend Invite

Send A Message

Whole Profile Feed

Latest News About Coder Profile

RSS News Feed

Coder Profile Poll

If you made money from keeping your profile up to date, say $30 and up, per month. What extra time would you spend on your profile?

No extra time
A few hours at weekends
A whole day each week
Every minute i can get free

please login to cast your vote
and see the results of this poll

Latest Coder Profile Changes

Coder Profile was last updated
1.78 Year Ago

RSS Development Blog Feed

Official Blog :: Make A Donation :: Credits :: Contact Me
Terms & Conditions :: Privacy Policy :: Documents :: Wallpapers