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.
©2024, by Bill Sanders, all rights reserved.
This domain had 355 different visits in the last 30 days.
This page was last modified on our server on 11 Jul 2021
and last refreshed on our server at 3:47 am, UTC
This file took 0.02318 seconds to process.