SELECT Statements
A SELECT statement can consist of the following basic clauses.
• SELECT
• INTO
• FROM
• JOIN
• WHERE
• GROUP BY
• HAVING
• UNION
• ORDER BY
• LIMIT
SELECT Syntax
The following syntax diagram outlines the syntax supported by the Google Contacts adapter:
SELECT {
[ TOP <numeric_literal> ]
{
*
| {
<expression> [ [ AS ] <column_reference> ]
| { <table_name> | <correlation_name> } .*
} [ , ... ]
}
[ INTO csv:// [ filename= ] <file_path> [ ;delimiter=tab ] ]
{
FROM <table_reference> [ [ AS ] <identifier> ]
}
[ WHERE <search_condition> ]
} | SCOPE_IDENTITY()
<expression> ::=
| <column_reference>
| @ <parameter>
| ?
| COUNT( * | { [ DISTINCT ] <expression> } )
| { AVG | MAX | MIN | SUM | COUNT } ( <expression> )
| NULLIF ( <expression> , <expression> )
| COALESCE ( <expression> , ... )
| CASE <expression>
WHEN { <expression> | <search_condition> } THEN { <expression> | NULL } [ ... ]
[ ELSE { <expression> | NULL } ]
END
| <literal>
| <sql_function>
<search_condition> ::=
{
<expression> { = | > | < | AND } [ <expression> ]
} [ { AND | OR } ... ]
Examples
1. Return all columns:
SELECT * FROM My Contacts
2. Rename a column:
SELECT "Fullname" AS MY_Fullname FROM My Contacts
3. Search data:
SELECT * FROM My Contacts WHERE Updated = '2017-03-15';
4.The Google Contacts APIs support the following operators in the WHERE clause: =, >, <, AND.
SELECT * FROM My Contacts WHERE Updated = '2017-03-15';