Tutorial On Simple SELECTs

Share this post!

Vote this!

In this lesson of the SQL tutorial, you will learn...

1. About the database we'll be using in class.
2. To comment your SQL code.
3. To understand SQL syntax.
4. To select all rows from a table.
5. To sort record sets.
6. To filter records. 

The SELECT statement is used to retrieve data from tables. SELECT statements can be used to perform simple tasks such as retrieving records from a single table or complicated tasks such as retrieving data from multiple tables with record grouping and sorting. In this lesson, we will look at several of the more basic ways to retrieve data from a single table.  more...