Topics

• SELECT
• Getting started with Microsoft SQL Server
• CASE

Examples

• Using the wildcard character to select all columns in a query.
• Selecting with Condition
• Select Individual Columns
• SELECT Using Column Aliases
• INSERT / SELECT / UPDATE / DELETE: the basics of Data Manipulation Language
• Use CASE to COUNT the number of rows in a column match a condition.
• Select columns which are named after reserved keywords