Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/9

Click to flip

9 Cards in this Set

  • Front
  • Back
Define alias and the format
Used for simplifying the column and table name. Alias can be anything like the first character of the name or its short form etc.

Format:
Select column_name as column alias
From table name as table alias
Define the primary key in join function
Primary key refers to the unique values for each row like employee ID, product ID etc.
How to join two tables?
To join two tables, at least one table must have the primary key which must also appear in another table that we want to join together
How to select name from employee table and product from product table by joing two tables together?
Select employee.name, product.product
From employee, product
Where employee.ID = product.ID
How to use inner join to select name from employee table and product from product table?
Select employee.name, product.product
From employee inner join product
On employee.ID = product.ID
What is the difference between inner join, left join, and right join?
Inner join - only show the rows which primary key match another row in another table

Left join - will show all the rows of the first table even though the primary key doesn't match the row with another table

Right join - show all the rows of the second table even though their primary key do not match with the row of another table
Define union function
Union is used to select the data from two tables.

But it will include all data into one column which you firstly specify at the select statement.

And it only select the unique value; it will not repeat the data twice if it appears more than once at the table.
Define union all
Same as union but it will select all values including the repeated ones.
Union format
Select column name from table 1 name
Union
Select column name from table 2 name