if you need this in sql server, you can use row_number for mysql, there is no equivalent of this, but you have a work around:
SQL Server:
USE AdventureWorks2008R2;
GO
WITH OrderedOrders AS
(
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
FROM Sales.SalesOrderHeader
)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 50 AND 60;
MySQL:
SELECT @i:=@i+1 AS iterator, t.* FROM tablename t,(SELECT @i:=0) foo
more info:
http://stackoverflow.com/questions/1895110/row-number-in-mysql[
^]