skip to main content
Supported SQL and Extensions : Oracle Eloqua, HubSpot, and Marketo : Select
 

Try DataDirect Cloud Now

Select

Use the Select statement to fetch results from one or more tables in a Marketo, HubSpot, or Oracle Eloqua data store.

Syntax

SELECT select_clause
from_clause
[where_clause]
[groupby_clause]
[having_clause]
[{UNION [ALL] } select_statement]
[orderby_clause]
where:
select_clause
specifies the columns from which results are to be returned by the query. See Select Clause for a complete explanation.
from_clause
specifies one or more tables on which the other clauses in the query operate. See From Clause for a complete explanation.
where_clause
is optional and restricts the results that are returned by the query. See Where Clause for a complete explanation.
groupby_clause
is optional and allows query results to be aggregated in terms of groups. See Group By Clause for a complete explanation.
having_clause
is optional and specifies conditions for groups of rows (for example, display only the departments that have salaries totaling more than $200,000). See Having Clause for a complete explanation.
UNION
is an optional operator that combines the results of the left and right Select statements into a single result. See Union Operator for a complete explanation.
orderby_clause
is optional and sorts the results that are returned by the query. See Order By Clause for a complete explanation.
* Select Clause
* From Clause