LIMIT

TSQL 2012 – OFFSET and FETCH

by SteveStedman
April 4, 2012July 28, 2015
CTE, SQL 2012, TSQL 2012

Its about time, MySQL has had a feature LIMIT which is similar to the usage of OFFSET and FETCH for years. Now in SQL Server… Read More »TSQL 2012 – OFFSET and FETCH

A Comparison of Oracle and MySQL

by SteveStedman
June 1, 2007March 7, 2012
Steve

MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE… Read More »A Comparison of Oracle and MySQL