SQL Select Statement Tutorial Restricting And Sorting Data | 2020 Best Practices

Two main objectives of this SQL Select Statement Tutorial about Restricting and Sorting Data are:
1. You will able to Limit the Rows retrieved by a query.
2. Sort the rows retrieved by a query.

Take note: In retrieving data from the database,  there are times that you need to restrict data to display. Because Not all the time you are retrieving all records from the database table. 

Basic Syntax used in this tutorial:

WHERE
 - it restricts the query to rows that meet the condition

Condition
 - It is composed of column names, expressions, constants, and comparison operators.
here's the link below for the OTHER COMPARISON OPERATORS.