Chapter 8, Problem 1HOA

Program Plan Intro

Basic form of the SQL SELECT command:

The basic form of the SQL SELECT command is given below:

Basic form: SELECT-FROM-WHERE

Explanation:

• The SQL SELECT command is used to retrieve given values in a database.
• From the given basic form, a After user type the word "SELECT", user list the columns that they want to include in the query results.
  • Next, user type the word "FROM" followed by table name that have the data user need to query.
  • Finally, user can list conditions that apply to the data they want to retrieve after the word "WHERE".