...
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
Code Block |
---|
SELECT * FROM t1customers LIMIT 5 |
...
The following query returns the
...
first 5 customers to be created
Code Block |
---|
...
SELECT * FROM customers ORDER BY created_date LIMIT 5 |
The following query returns the first 5 customers to be created
Code Block |
---|
SELECT * FROM |
...
customers |
...
ORDER BY |
...
created_date LIMIT 5 |
REGEX Column Specification
...