Answer: MySQL LIMIT clause equivalent for SQL SERVER

answer re: MySQL LIMIT clause equivalent for SQL SERVER

Jan 26 '12

28

In SQL Server 2012, there is support for the ANSI standard OFFSET / FETCH syntax. I blogged about this and here is the official doc (this is an extension to ORDER BY). Your syntax converted for SQL Server 2012 would be:

SELECT ID, Name, Price, Image 
  FROM Products 
  ORDER

…

Open Full Answer