Tag: LIMIT

TSQL 2012 – OFFSET and FETCH

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 2012 Microsoft introduces OFFSET and FETCH. The OFFSET and FETCH functionality is used to achieve

Posted in CTE, SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

A Comparison of Oracle and MySQL

MySQL is to Oracle as Linux is to Windows. Limiting Result Sets Oracle supports ROWNUM to limit the result Sets SELECT * FROM tablename WHERE rowmun < 10 MySql uses the LIMIT clause. SELECT * FROM tablename LIMIT 10 Bind

Posted in Steve Tagged with: , , , , , , ,