In this tutorial you will be learn how to use SELECT statement in MySQL and you can also learn how to use SELECT statement with WHERE clause. The SELECT statement is used to retrieve the records from the table.
The SELECT statement is used to retrieve the records from the table. There are some keywords uses in SELECT statement that are described in the following table.
|SELECT||SELECT statement is used to retrieve fields from one or more tables.|
|FROM||Tables containing to the fields.|
|WHERE||The WHERE clause is used to describe the criteria to restrict the records retrieved.|
|GROUP BY||The GROUP BY clause is used to determine how the records should be grouped.|
|HAVING||HAVING clause used with GROUP BY to define the criteria for grouped records|
|ORDER BY||The ORDER BY clause is used to described the criteria for ordering the record.|
|LIMIT||The LIMIT clause is used to restrict the limit of number of records retrieved.|