Walter Shields

SQL QuickStart Guide

Notify me when the book’s added
To read this book, upload an EPUB or FB2 file to Bookmate. How do I upload a book?
  • Marija Stojanovićhas quoted3 years ago
    SELECT
    *
    FROM
    invoices
    INNER JOIN
    customers
    ON
    invoices.CustomerId = customers.CustomerId
  • Marija Stojanovićhas quoted3 years ago
    joins allow us to access fields from different tables.
  • Marija Stojanovićhas quoted3 years ago
    ices with customer names.

    A JOIN clause merging both of these tables together would look like this:

    SELECT
    *
    FROM
    invoices
    INNER JOIN
    customers
    ON
    invoices.CustomerId = customers.CustomerId
  • Marija Stojanovićhas quoted3 years ago
    When querying with dates, use the same operators used when querying with numbers: =, >, <, BETWEEN, etc.
  • Marija Stojanovićhas quoted3 years ago
    When querying for dates, it is important to first take a look at how the date is stored in the table you are querying
  • Marija Stojanovićhas quoted3 years ago
    WHERE
    InvoiceDate = '2009-01-03 00:00:00'
  • Marija Stojanovićhas quoted3 years ago
    WHERE
    BillingCity NOT LIKE '%T%'
    ORDER BY
    Total
  • Marija Stojanovićhas quoted3 years ago
    WHERE
    BillingCity LIKE '%T%'
    ORDER BY
    Total
  • Marija Stojanovićhas quoted3 years ago
    SELECT InvoiceDate, BillingAddress, BillingCity, Total FROM invoices WHERE BillingCity LIKE 'T%' ORDER BY Total

    Počinje sa T -like'T%'

  • Marija Stojanovićhas quoted3 years ago
    Wildcard characters will always be enclosed in single quotation marks. Without quotation marks, % is an arithmetic operator known as modulo,
fb2epub
Drag & drop your files (not more than 5 at once)