Summary  
This chapter explains how to use SQL SELECT statements with optional filtering (WHERE, AND, OR) and how to execute those queries in code by iterating over a data reader and printing retrieved column values.

General domain of usage  
Retrieving data from a relational database

### Important Points
- The `OR` and `AND` keywords can be used for joining conditional statements;
- The `*` character can be used for selecting all the columns in a SELECT statement.


Which of the following are correct ways of writing a SELECT statement?

This course will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

This module will give you a solid foundation to begin making applications using .NET in C#. Covering console applications, asynchronous programming, web services, database fundamentals, and ADO.NET CRUD operations, you'll gain practical skills. From creating apps and handling exceptions to optimizing database access, this course ensures a robust understanding of essential .NET development concepts.

Read

General Syntax

Important Points