ICT SQL

ICT SQL

1. Select

   • Retrieves a record then other commands on record can be carried out

2. From

   • Identifies where the data comes from

3. Where

   • This sets out some condition to choose only certain records

4. And

   • Allows multiple conditions to be set all of which must be true

5. Or

   • Allows multiple conditions to be set any of which can be true

6. Like

   • Allows data that is like the criteria to be set