SQL Terms

2. a clause that lets you specify the maximum number of rows the result set will have.
7. creates a new table in the database. It allows you to specify the name of the table and the name of each column in the table.
8. a function that takes the name of a column as an argument and returns the largest value in that column.
11. a special operator used with the WHERE clause to search for a specific pattern in a column.
13. a clause in SQL that is only used with aggregate functions. It is used in collaboration with the SELECT statement to arrange identical data into groups.
14. lets you add columns to a table in a database.
16. indicates you want to filter the result set to include only rows where the following condition is true.
18. allow you to edit rows in a table.
19. used to create different outputs (usually in the SELECT statement). It is SQL’s way of handling if-then logic.
20. a function that takes a column name and an integer as arguments. It rounds the values in the column to the number of decimal places specified by the integer.
23. will combine rows from different tables if the join condition is true.
24. an operator that filters the result set to only include rows where either condition is true.
25. used to filter the result set within a certain range. The values can be numbers, text or dates.

1. a function that takes the name of a column as an argument and returns the smallest value in that column.
3. used to add a new row to a table.
4. clause lets you store the result of a query in a temporary table using an alias. You can also define multiple temporary tables using a comma and with one instance of the WITH keyword.
5. a function that takes the name of a column as an argument and returns the sum of all the values in that column.
6. specifies that the statement is going to be a query that returns unique values in the specified column(s).
9. an aggregate function that returns the average value for a numeric column.
10. will combine rows from different tables even if the join condition is not met. Every row in the left table is returned in the result set, and if the join condition is not met, then NULL values are used to fill in the columns from the right table.
12. used to remove rows from a table.
14. a keyword in SQL that allows you to rename a column or table using an alias.
15. an operator that combines two conditions. Both conditions must be true for the row to be included in the result set.
17. a clause that indicates you want to sort the result set by a particular column either alphabetically or numerically.
21. used to fetch data from a database. Every query will begin with SELECT.
22. a function that takes the name of a column as an argument and counts the number of rows where the column is not NULL.