SQL

SQL

1. Basics

   • Wildcards
     • *
       • Returns all fields
     • %
       • Used to show that it doesn't matter what comes before it.
   • SELECT
     • Tells database what information you want it to retrieve.
   • FROM
     • Tells data base which tables to look in.
   • WHERE
     • Specifies conditions that a record must satisfy before returned.
   • ORDER BY
     • Used to sort records into ascending (AC) or descending (DC).
   • Boolean
     • AND
     • OR