SQL Select Statement Tutorial Restricting And Sorting Data | 2020 Best Practices
6K views
·
Dec 11, 2021
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.
Show More
Show LessComments
loading text loading
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text
loading text loading
loading text