L-W Flashcards
(27 cards)
Returns all rows from the left table and matching rows from the right table
Left Join
Searches for a specific pattern in a column
Like
Specifies the number of records to return in the result set
Limit
Only includes rows where a condition is not true
Not
A constraint that enforces a column to not accept NULL values
Not Null
Includes rows where either condition is true
Or
Sorts the result set in ascending or descending order
Order By
Returns all rows when there is a match in either left table or right table
Outer Join
A constraint that uniquely identifies each record in a database table
Primary Key
A stored procedure
Procedure
Returns all rows from the right table and the matching rows from the left table
Right Join
Specifies the number of records to return in the result set
Rownum
Selects data from a database
Select
Selects only distinct (different) values
Select Distinct
Copies data from one table into a new table
Select Into
Specifies the number of records to return in the result set
Select Top
Specifies which columns and values that should be updated is a table
Set
Creates a table or adds deletes or modifies columns in a table or deletes a table or data inside a table
Table
Specifies the number of records to return in the result set
Top
Deletes the data inside a table but not the table itself
Truncate Table
Combines the result set of two or more Select statements (only distinct values)
Union
Combines the result set of two or more Select statements (allows duplicate values)
Union All
A constraint that ensures that all values in a column are unique
Unique
Updates existing rows in a table
Update
