8. Editing the Result

Order by and Limit can impact the results of a query.

Order by

Order by allows you to sort the result table based on a specific criterion. If Order by is not used, the results will appear in a random order.

To use Order by, select the desired column, then choose either descending or ascending. If multiple columns are selected, the first one selected will have a higher priority in Order by.

Limit

Limit refers to the maximum number of rows in the table that can be viewed in the query result. You can choose from 10, 100, 1000, or 10000.