SQL Tutorial 5: SELECT statement

Description:
Use SELECT statement to display the content of column/s in an instance of a row or record in tables. SELECT [set of column names] FROM statement is one of a powerful data manipulation language (DML) commands that makes SQL. The syntax of this statement is standardized either you are using DB2, MySQL, Informix, Oracle, or SQL Server.

Issue asterisk (*) or star if you want to display all data inside a table. A table may contain a thousand or millions of record. In order to display specific criterion that you search, issue a WHERE clause that specifies the filter condition.

WHERE clause works effectively with comparison operators such as greater than, less than, equal to, greater than equal, less than equal, or NOT EQUAL operators. Use BETWEEN-AND if you a filtering amount or date ranges. The IN operator filters only specific string of column data that you may want in your listing.

Logical operators such as AND, OR, NOT may be used if you have a compound filtering conditions.

To understand fully on how this is formed to may a powerful SELECT statement, the video shows specific problems with solutions on how to solve a given selection criteria. Included in the examples are filtering using specific data with IN operator, filtering a set of range amount with BETWEEN AND combination, and with comparison operators.

Link for the ebook will be announced later.