The SELECT statement is by far the most common element of SQL. SELECT, with its ORDER BY capabilities and many other uses, is a powerful core SQL statement.
In this module, you learned more about the SELECT statement and how you can put it to use to get the information you need in the format you need it. Using the ability to limit the columns returned and to filter the results means that you can get very specific, small results sets.
This means that the information you need is immediately usable.
SQL SELECT Syntax
SELECT column_name,column_name
FROM table_name;
and
SELECT * FROM table_name;
The WHERE clause is used to filter records.
The SQL WHERE Clause
The WHERE clause is used to extract only those records that fulfill a specified criterion.
SQL WHERE Syntax
SELECT column_name,column_name
FROM table_name
WHERE column_name operator value;