+----------+
| count(*) |
+----------+
| 10       |
+----------+

Returned 1 rows with 1 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 4     | four  | 50    | 32.120000|
| 5     | five  | 50    | 32.130000|
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 10 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 4     | four  | 50    | 32.120000|
| 5     | five  | 50    | 32.130000|
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 10 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 8     | eight | 30    | 58.120000|
| 5     | five  | 50    | 32.130000|
| 4     | four  | 50    | 32.120000|
| 9     | nine  | 30    | 57.120000|
| 1     | one   | 10    | 42.120000|
| 7     | seven | 50    | 59.120000|
| 6     | six   | 50    | 32.140000|
| 10    | ten   | 30    | 56.120000|
| 3     | three | 10    | 44.120000|
| 2     | two   | 10    | 43.120000|
+-------+-------+-------+--------+

Returned 10 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 10    | ten   | 30    | 56.120000|
| 9     | nine  | 30    | 57.120000|
| 8     | eight | 30    | 58.120000|
| 7     | seven | 50    | 59.120000|
| 6     | six   | 50    | 32.140000|
| 5     | five  | 50    | 32.130000|
| 4     | four  | 50    | 32.120000|
| 3     | three | 10    | 44.120000|
| 2     | two   | 10    | 43.120000|
| 1     | one   | 10    | 42.120000|
+-------+-------+-------+--------+

Returned 10 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 10    | ten   | 30    | 56.120000|
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 1     | one   | 10    | 42.120000|
| 9     | nine  | 30    | 57.120000|
| 4     | four  | 50    | 32.120000|
| 5     | five  | 50    | 32.130000|
| 8     | eight | 30    | 58.120000|
+-------+-------+-------+--------+

Returned 10 rows with 4 columns
+----+-------+------+--------+
| id | text1 | int1 | float1 |
+----+-------+------+--------+
| 5  | five  | 50   | 32.130000|
+----+-------+------+--------+

Returned 1 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 4     | four  | 50    | 32.120000|
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 9 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 4     | four  | 50    | 32.120000|
+-------+-------+-------+--------+

Returned 4 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 4     | four  | 50    | 32.120000|
| 5     | five  | 50    | 32.130000|
+-------+-------+-------+--------+

Returned 5 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 5 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 5     | five  | 50    | 32.130000|
| 6     | six   | 50    | 32.140000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 6 rows with 4 columns
+-------+-------+-------+--------+
| id    | text1 | int1  | float1 |
+-------+-------+-------+--------+
| 1     | one   | 10    | 42.120000|
| 2     | two   | 10    | 43.120000|
| 3     | three | 10    | 44.120000|
| 7     | seven | 50    | 59.120000|
| 8     | eight | 30    | 58.120000|
| 9     | nine  | 30    | 57.120000|
| 10    | ten   | 30    | 56.120000|
+-------+-------+-------+--------+

Returned 7 rows with 4 columns
+------------+-----------+-------------+
| min(text1) | sum(int1) | sum(float1) |
+------------+-----------+-------------+
| one        | 30        | 129.360000  |
| five       | 200       | 155.510000  |
| eight      | 90        | 171.360000  |
+------------+-----------+-------------+

Returned 3 rows with 3 columns
+------------+-----------+-------------+
| min(text1) | sum(int1) | sum(float1) |
+------------+-----------+-------------+
| five       | 200       | 155.510000  |
+------------+-----------+-------------+

Returned 1 rows with 3 columns