SQL:Data Query Language

Introduction
The Data Query Language (DQL)is used to display the data in a table or tables. The following SQL Commands are available:
 * SELECT

DDL Example
In the heights database the following DQL commands were sent to MySQL:

Backus-Naur Form
SELECT Syntax

Examples
Thsi lists all the people and all the fields in the People table

This selects all the fields (indicated by *) from the People table (tblPeople) and sorts them (ORDER BY) their heights.