The SELECT Clause
Explore how to use the SQL SELECT clause to fetch data from database tables. Learn the syntax for selecting specific columns or all columns using the asterisk and see practical examples with customer data.
We'll cover the following...
We'll cover the following...
The SELECT clause
The SQL SELECT statement is used to fetch the data from a database table that returns this data in the form of a result table. These result tables are called result-sets.
Syntax
The basic syntax of the SELECT statement is as follows:
SELECT column1, column2, ... columnN