Lesson 10

SQL Select Statement Conclusion

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;

SQL Relational Theory