SQL+Questions

You will find the answers to the following questions in "Higher Information Systems", Charlie Love, Chapter 6 and also on the website []

1. Identify and describe the 3 parts of SQL 2. What is the purpose of the SQL SELECT query? 3. Show an example of an SQL statement which joins 2 tables 4. What is the SQL clause which can be used to sort data in a query 5. For each part answered in (1) above, give 1 SQL example and explain its meaning 6. Research the following SQL statements and clauses and operators writing a sentence explaining each one: (a) LIKE (b) TOP (c) UPDATE (d) DELETE (e) % wildcard