Basic SQL
SQL JOINS
SQL Operators
SQL Functions 1
SQL Functions 2
100

This word starts a SQL query.

What is Select?

100

Used to retrieve rows where matching values exist in both tables

What isan Inner Join ?

100

This word connects two or more tables in the join condition

What is on?

100
This function lists the current date.
What is sysdate?
100

This function extends the functionality of the INSTR function by letting you search a string for a regular expression pattern 

What is REGEXP_INSTR?

200
This word references a table name.
What is From?
200

Used to retrieve all rows from the left table and matching rows from the right table

What is a LEFT Join?

200

This uniquely identifies each record in a table and ensures strong data integrity 

What is a Primary Key?

200
This function brings back the value in capital letters.
What is upper?
200

This function returns the date date plus integer months 

What is ADD_MONTHS?

300
This symbol brings back all the rows and columns.
What is *?
300

This Join is used in displaying NULL values where no match exists in the left table.

What is a Right Join?

300

This operator returns the remainder of an equation

What is modulus %

300

This function brings back the final day of the month.

What is last_day?

300
This function makes the first letter of each word capitalized.
What is initcap?
400

This word limits the data brought back.

What is Where or What is Having?

400

Type of INNER JOIN that automatically joins two tables based on columns with the same name and data type

What is a Natural Join

400
This operator searches for a pattern of letters.
What is like?
400
This function brings back a certain number of characters for each value.
What is substr?
400
This function bring back the value in small letters.
What is lower?
500
This symbol ends a SQL statement.
What is ; ?
500

This returns all rows in both tables that match the query's WHERE clause

What is a FULL OUTER JOIN ?

500

This operator gives a list of values that are in a specified conditon.

What is in?

500

This function gives a value if nothing is listed in that column.

What is NVL/NVL2?

500
This function joins two columns together with the || symbol.
What is concatenation?
M
e
n
u