Python MySQL Order By and Limit:
(1) Order By- When you use the SELECT statement to query data from a table, the result set is not sorted in any order. To sort the result set, you use the ORDER BY clause. The ORDER BY clause allows you to-
- Sort a result set by a single column or multiple columns.
- Sort a result set by different columns in ascending or descending order.
(2) Limit- The LIMIT clause is used in the SELECT statement to constrain the number of rows in a result set. The LIMIT clause accepts one or two arguments. The values of both arguments must be zero or positive integers.
(3) The following data is present in the database table as shown below.
| We can use the PyCharm code editor for this example. If you do not know about it then follow this link- How to install PyCharm for Python and create a program in it. |
(4) Example of Order By Statement:
- In this example, we use the order by statement to manage the employee_table data in descending order (DESC) by implementing a query on emp_id. For this, we write the following query as shown below.
- In this example, we use the order by statement to manage the employee_table data in Ascending order (ASC) by implementing a query on emp_name. For this, we write the following query as shown below.
(5) Example of Limit Statement:
- In the limit statement, we pass two parameters. Example- (1,2) here 1 defines the position of value after which you have to take the row and 2 represents the number of rows to be shown. If you take (0,3) on emp_id then it will display data of emp_id 1,2 and 3. If you take (2,2) on emp_id then it will display data of emp_id 3 and 4.
