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 Drive 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> ]
[
ORDER BY
<column_reference> [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
]
[
LIMIT <expression>
]
} | 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 | IN | LIKE | >,<,=,<=,>= } [ <expression> ]
} [ { AND | OR } ... ]
Examples
1. Return all columns:
SELECT * FROM Files
2. Rename a column:
SELECT "Name" AS MY_Name FROM Files
3. Search data:
SELECT * FROM Files WHERE Extension = 'png';
4.The Google Drive APIs support the following operators in the WHERE clause: =, AND, IN, LIKE, >,<,=,<=,>=.
SELECT * FROM Files WHERE Extension = 'png';
5.Sort a result set in ascending order:
SELECT Id, Name FROM Files ORDER BY Name ASC