Summary sql keywords: fundamenten en toepassingen in query’s

Here are the keywords used in SQL queries, extracted from your slides:

1. SELECT – Retrieves data from tables

2. FROM – Specifies the table to query

3. WHERE – Sets conditions to filter records

4. DISTINCT – Eliminates duplicate rows in results

5. AND – Combines multiple conditions (logical intersection)

6. OR – Combines multiple conditions (logical union)

7. IN – Checks if a value exists within a set of values

8. NOT – Excludes specified values from the results

9. BETWEEN – Specifies a range of values

10. LIKE – Finds patterns in strings using wildcards

11. ORDER BY – Sorts query results

12. COUNT – Counts rows that match the criteria

13. MIN – Finds the minimum value in a column

14. MAX – Finds the maximum value in a column

15. SUM – Calculates the sum of values in a column

16. AVG – Calculates the average of values in a column

17. GROUP BY – Groups rows sharing a property to aggregate data

18. HAVING – Filters groups of rows defined by the GROUP BY clause

19. JOIN – Combines rows from multiple tables based on related columns

20. INNER JOIN – Returns records with matching values in both tables

21. LEFT JOIN (LEFT OUTER JOIN) – Returns all records from the left table and matched records
from the right table

22. RIGHT JOIN (RIGHT OUTER JOIN) – Returns all records from the right table and matched
records from the left table

23. ON – Specifies the condition for the join