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
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
