Review



In these lessons, we learned the following queries:

Practice all of these concepts on a different table. You may cut and paste from the list above. Be sure to adjust the table name and field names accordingly.

Then, take a test.

Note: If you have data in two separate tables, you can join the data together to act as if it were one table. When joining tables, or just when selecting data from different tables, field names may be the same from each table, which may make selecting them difficult. In this case, use aliases.

For more on SQL, see Guru99


Distinct, Order By   < <  PREVIOUS   Table of Contents NEXT  > >   PHP Introduction

Developed with HTML-Kit
Sandersongs Web Tutorials
Contact the Webmasterwith comments.
©2017, by Bill Sanders, all rights reserved.
This domain had 3,982 different visits in the last 30 days.
435,548 hits on this domain since 24 Nov 2006.
http://www.sandersongs.com/PHPsqlCourse/SQL10.php
This page was last modified on our server on 25 Apr 2017
and last refreshed on our server at 3:55 am, MST
This file took 0.01458 seconds to process.