Page History

...

A single argument stands for the maximum number of rows and the offset defaults to 0.

The Limit indicates the number of rows to be returned. The rows returned are chosen at random. The following query returns 5 rows from t1 at random.arbitrary customers

SELECT * FROM t1customers LIMIT 5

...

The following query returns the

...

first 5 customers to be created

...

SELECT * FROM customers ORDER BY created_date LIMIT 5

The following query returns the first 5 customers to be created

SELECT * FROM 

...

customers 

...

ORDER BY 

...

created_date LIMIT 5

REGEX Column Specification

...