Lesson 10
SQL Select Statement Conclusion
The
In this module, you learned more about 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;
