<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title>How to make LIMIT (from, to) in MSSQL 2005</title>
		<description>Discuss How to make LIMIT (from, to) in MSSQL 2005</description>
		<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html</link>
		<lastBuildDate>Mon, 06 Apr 2026 23:11:04 +0000</lastBuildDate>
		<generator>JComments</generator>
		<atom:link href="https://select-sql.com/jcomments/rss/com_content/1" rel="self" type="application/rss+xml" />
		<item>
			<title>insano says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-118</link>
			<description><![CDATA[:D thanks, it works!]]></description>
			<dc:creator>insano</dc:creator>
			<pubDate>Thu, 27 Sep 2012 13:14:35 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-118</guid>
		</item>
		<item>
			<title>Achmad Sultoni says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-111</link>
			<description><![CDATA[thanks a lot. It's work for my project :-)]]></description>
			<dc:creator>Achmad Sultoni</dc:creator>
			<pubDate>Thu, 02 Aug 2012 02:08:06 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-111</guid>
		</item>
		<item>
			<title>shankan says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-70</link>
			<description><![CDATA[hi, thank you lot for your kind help..]]></description>
			<dc:creator>shankan</dc:creator>
			<pubDate>Fri, 20 Apr 2012 02:31:59 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-70</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-69</link>
			<description><![CDATA[shankan: Hi, for v 2000, is subqueries with 2 TOPs and ASC/DESC working way. New T-SQL commands since v 2005 is one of the good reason for update, but of course you can do same results it in older version, just not so easy.]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 19 Apr 2012 12:27:16 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-69</guid>
		</item>
		<item>
			<title>shankan says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-68</link>
			<description><![CDATA[mssql, v 2000... thank you for your quick respond. i found a working one for Ms Sql 2000. --------------- --------------- ----------- SELECT * FROM (	SELECT TOP 5 * FROM (	SELECT TOP 20 *	FROM info_stkbalance 	--WHERE conditions	ORDE R BY info_stkbalance .id ASC) as foo	ORDER by id DESC) as bar ORDER by id ASC --------------- --------------- -----------]]></description>
			<dc:creator>shankan</dc:creator>
			<pubDate>Thu, 19 Apr 2012 10:52:13 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-68</guid>
		</item>
		<item>
			<title>ViDom says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-67</link>
			<description><![CDATA[ This error speaks about that that it is time to delete MSSQL]]></description>
			<dc:creator>ViDom</dc:creator>
			<pubDate>Thu, 19 Apr 2012 09:49:42 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-67</guid>
		</item>
		<item>
			<title>ViDom says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-66</link>
			<description><![CDATA[MSSQL this big misunderstandin g which I saw. I advise to all not to use this database for good projects. The good request with paggings in other databases perfectly looks, and in MSSQL turns into a pun and becomes the unreadable. The most interesting appears, when start to do groups and sortings. "row_number() OVER" couldn't help even. Good night. 8)]]></description>
			<dc:creator>ViDom</dc:creator>
			<pubDate>Thu, 19 Apr 2012 09:48:05 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-66</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-65</link>
			<description><![CDATA[shankan: What SQL are you using and what version? This is working for MS SQL 2005 and higher.]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 19 Apr 2012 08:26:52 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-65</guid>
		</item>
		<item>
			<title>shankan says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-64</link>
			<description><![CDATA[hi, i also faced that, [Err] 42000 - [SQL Server]'row_num ber' is not a recognized function name. how i do that?]]></description>
			<dc:creator>shankan</dc:creator>
			<pubDate>Thu, 19 Apr 2012 03:37:03 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-64</guid>
		</item>
		<item>
			<title>Nilesh Patel says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-55</link>
			<description><![CDATA[Thanks]]></description>
			<dc:creator>Nilesh Patel</dc:creator>
			<pubDate>Tue, 20 Dec 2011 08:04:14 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-55</guid>
		</item>
		<item>
			<title>ranjith says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-50</link>
			<description><![CDATA[:-* Thanks :)]]></description>
			<dc:creator>ranjith</dc:creator>
			<pubDate>Sat, 20 Aug 2011 01:48:22 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-50</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-49</link>
			<description><![CDATA[ I don't understand your question. In example we are not using ID column. Your example should work, so try explain more what you are looking for.]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Thu, 18 Aug 2011 22:17:38 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-49</guid>
		</item>
		<item>
			<title>ViDom says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-45</link>
			<description><![CDATA[How to???????????: SELECT [title],SUM([co unt]) AS count FROM [test].[dbo].[p osts] GROUP BY [title] ORDER BY [title]; I have not ID column )))]]></description>
			<dc:creator>ViDom</dc:creator>
			<pubDate>Sun, 14 Aug 2011 11:14:58 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-45</guid>
		</item>
		<item>
			<title>anon says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-41</link>
			<description><![CDATA[MS SQL :-x 8) PGSQL and MySQL :P]]></description>
			<dc:creator>anon</dc:creator>
			<pubDate>Thu, 24 Mar 2011 04:07:20 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-41</guid>
		</item>
		<item>
			<title>Han Mai says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-39</link>
			<description><![CDATA[ ROW_NUMBER() is a function in SQL SERVER 2K5 or higher. ;-)]]></description>
			<dc:creator>Han Mai</dc:creator>
			<pubDate>Thu, 24 Feb 2011 09:10:50 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-39</guid>
		</item>
		<item>
			<title>Magnus says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-29</link>
			<description><![CDATA[Thanks for your Tipp. Great idea.]]></description>
			<dc:creator>Magnus</dc:creator>
			<pubDate>Thu, 15 Jul 2010 13:35:24 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-29</guid>
		</item>
		<item>
			<title>ALien says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-7</link>
			<description><![CDATA[Jup ;-) thx :-) Poland thx]]></description>
			<dc:creator>ALien</dc:creator>
			<pubDate>Thu, 13 Dec 2007 16:24:33 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-7</guid>
		</item>
		<item>
			<title>martijn says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-6</link>
			<description><![CDATA[hi guys, nice query, I tried and it works but... at my first page I get 20 records and all the following pages 21. so I made a little adjustment, (I added +1 @start) Would like to here if it is oke, or I am doing something wrong Debug: SELECT * FROM (SELECT row_number() OVER (ORDER BY User_Name) AS rownum, User_ID,User_Na me,Telephone,Mo bile,User_Activ e FROM [User]) AS A WHERE A.rownum BETWEEN (0+1) AND (0 + 20) Ciao, Martin]]></description>
			<dc:creator>martijn</dc:creator>
			<pubDate>Sun, 02 Dec 2007 12:01:33 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-6</guid>
		</item>
		<item>
			<title>Broken Arrow says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-9</link>
			<description><![CDATA[This method doesn't support ordering over calculated fields! Any work around?]]></description>
			<dc:creator>Broken Arrow</dc:creator>
			<pubDate>Sun, 18 Nov 2007 10:46:00 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-9</guid>
		</item>
		<item>
			<title>arty says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-5</link>
			<description><![CDATA[very nice]]></description>
			<dc:creator>arty</dc:creator>
			<pubDate>Thu, 11 Oct 2007 22:23:05 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-5</guid>
		</item>
		<item>
			<title>Stanislav Duben says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-2</link>
			<description><![CDATA[Hi row_number() is new T-SQL command. This feature has syntax: SELECT Row_name FROM (SELECT row_number() OVER (ORDER BY Column) as Row_name) Another example: SELECT Description, Date FROM (SELECT ROW_NUMBER() OVER (ORDER BY Date DESC) AS Row, Description, Date FROM LOG) AS LogWithRowNumbe rs WHERE Row >= 1 AND Row ]]></description>
			<dc:creator>Stanislav Duben</dc:creator>
			<pubDate>Sat, 08 Sep 2007 12:37:42 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-2</guid>
		</item>
		<item>
			<title>Joey says:</title>
			<link>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-1</link>
			<description><![CDATA[In you example, what is row_number(), I have tried using 10 on replace row_number() and its not working. You never declared row_number()]]></description>
			<dc:creator>Joey</dc:creator>
			<pubDate>Fri, 07 Sep 2007 19:07:54 +0000</pubDate>
			<guid>https://select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html#comment-1</guid>
		</item>
	</channel>
</rss>
