Filemaker Switch ODBC Instrukcja Użytkownika Pobierz pdf (Strona 40)

40 FileMaker ODBC and JDBC Guide

SELECT Sales_Data.Time_Sold FROM Sales_Data

WHERE Sales_Data.Time_Sold < '12:00:00'

SELECT Sales_Data.Company_Name FROM Sales_Data

WHERE Sales_Data.Company_Name LIKE '%University'

SELECT Sales_Data.Company_Name FROM Sales_Data

WHERE Sales_Data.Company_Name NOT LIKE '%University'

SELECT Sales_Data.Amount FROM Sales_Data WHERE Sales_Data.Amount IS NULL

SELECT Sales_Data.Amount FROM Sales_Data WHERE Sales_Data.Amount IS NOT

NULL

SELECT Sales_Data.Invoice_ID FROM Sales_Data

WHERE Sales_Data.Invoice_ID BETWEEN 1 AND 10

SELECT COUNT(Sales_Data.Invoice_ID) AS agg

FROM Sales_Data WHERE Sales_Data.INVOICE_ID IN (50,250,100)

SELECT COUNT(Sales_Data.Invoice_ID) AS agg

FROM Sales_Data WHERE Sales_Data.INVOICE_ID NOT IN (50,250,100)

SELECT COUNT(Sales_Data.Invoice_ID) AS agg FROM Sales_Data

WHERE Sales_Data.INVOICE_ID NOT IN (SELECT Sales_Data.Invoice_ID

FROM Sales_Data WHERE Sales_Data.Salesperson_ID = 'SP-4')

SELECT *

FROM Sales_Data WHERE EXISTS (SELECT Sales_Data.Amount

FROM Sales_Data WHERE Sales_Data.Salesperson_ID IS NOT NULL)

SELECT *

FROM Sales_Data WHERE Sales_Data.Amount = ANY (SELECT Sales_Data.Amount

FROM Sales_Data WHERE Sales_Data.Salesperson_ID = 'SP-1')

SELECT *

FROM Sales_Data WHERE Sales_Data.Amount = ALL (SELECT Sales_Data.Amount

FROM Sales_Data WHERE Sales_Data.Salesperson_ID IS NULL)

Logical operators

You can combine two or more conditions. The conditions must be related by AND or OR, such as:

salary = 40000 AND exempt = 1

The logical NOT operator is used to reverse the meaning, such as:

NOT (salary = 40000 AND exempt = 1)

Examples

SELECT * FROM Sales_Data WHERE Sales_Data.Company_Name

NOT LIKE '%University' AND Sales_Data.Amount > 3000

SELECT * FROM Sales_Data WHERE (Sales_Data.Company_Name

LIKE '%University' OR Sales_Data.Amount > 3000)

AND Sales_Data.Salesperson_ID = 'SP-1'

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 57 58

Brak uwag

Filemaker Switch ODBC Instrukcja Użytkownika Strona 40