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/16

Click to flip

16 Cards in this Set

  • Front
  • Back
What are the two required clauses for a SELECT statement?
SELECT and FROM
What is the purpose of a SELECT statement?
To allow the user to retrieve data from a database.
What does the * in the Select statement represent?
That the user wishes to select all of the data from a table in a database.
What is the purpose of a column alias?
To change the heading of a column
How to indicate a column alias is being used?
Example 1
----------
SELECT name NAME
FROM whatever

EXAMPLE 2
---------
SELECT title AS "THE TITLE"
FROM BOOKS;
What are the guidelines you should follow when using a column alias?
If the column alias contains spaces, special symbols, or you do not want it to appear in capital letters, it must be enclosed in double quotations.
How can you concatenate columns in a query?
Using concantenation operator ||

SELECT firstname || lastname
FROM CUSTOMERS;
How do you indicate a linebreak should occur in the output of a query?
CHR(10)
Which clause is used to restrict the number of rows returned from a query?
WHERE
Which clause displays the results of a query in a specific sequence?
ORDER BY
Which operator would be used to find any books with a retail price at least $24.00?
>
Which operator is used to find NULL values?
IS NULL

SELECT lastname
FROM CUSTOMERS
WHERE lastname IS NULL;
The IN comparison operator is similar to which logical operator?
=
When should single quotation marks be used in a WHERE clause?
When using any string literal
WHat does a % character represent in terms of the LIKE operator?
THE % represents any number of characters
When should an (_) underscore be used witht he LIKE operator?
Underscore represnts exactly one character in the indicated position.