Python & SQLite: Format Results & Order By
Welcome to another SQLite tutorial, in this tutorial we are going to look at order by clause in SQL and how we can format the output, so that it looks better.
We are using the module pretty table to format the results.
Link: https://pypi.org/project/prettytable/
So lets talk about the ORDER BY clause.
The ORDER BY keyword is used to sort the result-set in ascending or descending order.
The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
Keyboard I Use: https://amzn.to/2NgjPFV
(Affiliate Link, Helps the Channel)
On this page of the site you can watch the video online Python & SQLite: Format Results & Order By with a duration of hours minute second in good quality, which was uploaded by the user BitCode 19 April 2021, share the link with friends and acquaintances, this video has already been watched 611 times on youtube and it was liked by 18 viewers. Enjoy your viewing!
