Operators
=
What is equal to?
Two-dimensional structure with rows and columns.
What is a table
Specifies how data is sorted in a result set.
What is sort order?
ASC or DESC
What are sort orders?
This join selects all rows from both participating tables as long as there is a match between the columns.
Inner Join
>
<
What is greater than and
What is less than?
This uniquely identifies a row in a table.
What is a primary key?
Specifies the table that data is selected from.
What is the FROM clause?
The default direction for ORDER BY
What is ASC?
This join returns all records from the left table (table1), and the matching records from the right table (table2).
What is a Left Join?
>=
<=
What is greater than or equal and
What is less than or equal?
The data-type in a field is text.
What is string?
SELECT * FROM payroll;
What selects everything from the payroll table?
* % _
This join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join.
What is a Right Join?
And
OR
What can you use to combine conditions?
A type of database that connects tables to each other.
What is a relational database?
SELECT DISTINCT
What statement eliminates duplicates?
Returns counts, sums, averages, minimums and maximums per group.
What is Group By?
This join returns all (matched or unmatched) rows from the tables on both sides of the join clause.
What is a Full Outer Join?
!= or <>
What is not equal?
Structured Query Language
What is SQL?
Where
What sets the conditions for the select query?
How many primary keys can you have?
This operator combines the result sets of two different queries. Column data types in the two queries must match.
What is a Union?