Unit XII – Simple Queries in SQL
- Introduction
- Some MySQL Elements
- Literals
- Data Types
- Null Values
- Comments
- SQL Command Syntax
- Sample Database
- Making Simple Queries
- Accessing Database
- The SELECT Command
- Selecting all Columns
- Reordering Columns in Query Results
- Eliminating Redundant Data (with keyword DISTINCT)
- Selecting from all the Rows – All Keyword
- Viewing Structure of Table
- How to Perform Simple Calculations?
- Scalar Expressions with Selected Fields
- Using Column Aliases
- Handling Nulls
- Putting Text in the Query Output
- Selecting Specific Rows – WHERE clause
- Relational Operators
- Logical Operators
- Condition Based on a Range
- Condition Based on a List
- Condition Based on Pattern Matches
- Searching for NULL
- Operator Precedence
- Sorting Results – ORDER BY clause
- MySQL Functions
- String Functions
- Numeric Functions
- Date and Time Functions
- Aggregate Functions