en
Walter Shields

SQL QuickStart Guide

Сообщить о появлении
Загрузите файл EPUB или FB2 на Букмейт — и начинайте читать книгу бесплатно. Как загрузить книгу?
  • Marija Stojanovićцитирует3 года назад
    SELECT
    *
    FROM
    invoices
    INNER JOIN
    customers
    ON
    invoices.CustomerId = customers.CustomerId
  • Marija Stojanovićцитирует3 года назад
    joins allow us to access fields from different tables.
  • Marija Stojanovićцитирует3 года назад
    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ćцитирует3 года назад
    When querying with dates, use the same operators used when querying with numbers: =, >, <, BETWEEN, etc.
  • Marija Stojanovićцитирует3 года назад
    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ćцитирует3 года назад
    WHERE
    InvoiceDate = '2009-01-03 00:00:00'
  • Marija Stojanovićцитирует3 года назад
    WHERE
    BillingCity NOT LIKE '%T%'
    ORDER BY
    Total
  • Marija Stojanovićцитирует3 года назад
    WHERE
    BillingCity LIKE '%T%'
    ORDER BY
    Total
  • Marija Stojanovićцитирует3 года назад
    SELECT InvoiceDate, BillingAddress, BillingCity, Total FROM invoices WHERE BillingCity LIKE 'T%' ORDER BY Total

    Počinje sa T -like'T%'

  • Marija Stojanovićцитирует3 года назад
    Wildcard characters will always be enclosed in single quotation marks. Without quotation marks, % is an arithmetic operator known as modulo,
fb2epub
Перетащите файлы сюда, не более 5 за один раз