the MS SQL equivalent to MySQL's 'limit' command

Posted by dustin on February 11, 2004 with category tags of MySQL Microsoft

20 comments

I THINK IT WILL HELP THOSE HAVE THE SAME DOUBT

My thoughts exactly.    → comment by chrisdye (#15) on February 12, 2004 thanks you helped me like nythin    → comment by SUNIL KARTIKEY on September 21, 2004 I think anybody can get to like nythin if they give it a chance.    → comment by dye! on September 23, 2004 well almost, starting with MySQL 4 you can do LIMIT 10, 1000 which will give you a block of 1000 records starting at 10 is there anything similar to this in sql server? i don't think so.    → comment by andrew on August 22, 2005 limit x, y - MySQL MSSQL version : select top y * from <table> where <unique id> not in (select top x <unique id> from <table> order by <unique id>) from <table> order by <unique id>    → comment by Rustans Cubao on March 2, 2006 there are at least 2 solutions: select top * from ( select top * from table order by column ) order by column and select * from ( select top * from ( select top (+) from table order by column ASC ) T1 order by column DESC ) T2 order by column ASC I "think" the first is better    → comment by florin on June 5, 2006 Y si lo manejamos con el between? where id between x and y ?    → comment by Juan Pablo on June 26, 2007 Juan Pablo, el "between" no funciona sobre MSSQL... Hasta luego !    → comment by olag4277 on July 10, 2007 Florin, Don't think your solution will work, well the first one doesn't. If I want records 1 through 5 or 0 through 5 it doesn't account for that.    → comment by Anonymous on July 24, 2007 How you can do it is described on http://www.select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html    → comment by Stanislav Duben on August 22, 2007 This method doesn't support ordering over calculated fields! Any work around?    → comment by Broken Arrow on November 18, 2007 AND YOU WANT TO SELECT 3RD TO 5TH TOP SCORERS YOU USE :- SELECT TOP 3 * FROM MARKS WHERE ID NOT IN (SELECT TOP 2 * ID FROM MARKS ORDER BY TOT_MARKS) ORDER BY TOT_MARKS OUTPUT WILL BE-> SUPPOSE THERE IS A TBALE AS MARKLIST LIKE TABLE : MARKS ID NAME TOT_MARKS 1 ANDREWS 50 2 SYMONDS 25 3 MATHEW 70 4 ROY 40 5 MARY 35 6 CLINTON 65 7 MARCEL 80 8 PABLO 60 ID NAME TOT_MARKS 3 MATHEW 70 4 ROY 40 5 MARY 35