SQL Standard
This section discusses the SQL syntax for the Lyftrondata driver. Our driver adheres to ANSI standards, and all of our Python drivers adhere to the Sql Alchemy framework.
Select Statements
The Lyftrondata driver for Agilecrm provides ANSI SQL standard support. A SELECT statement can consist of the following basic clauses.
SELECT
INTO
FROM
JOIN
WHERE
GROUP BY
HAVING
UNION
ORDER BY
LIMIT
PAGESIZE LIMIT
SELECT Syntax
The following syntax diagram outlines the syntax supported by the SQL engine of the provider:
Examples
Return all columns:
Rename a column:
Cast a column's data as a different data type:
Search data:
Return the number of items matching the query criteria:
Return the number of unique items matching the query criteria:
Return the unique items matching the query criteria:
Summarize data:
Retrieve data from multiple tables.
Sort a result set in ascending order:
Restrict a result set to the specified number of rows:
Parameterize a query to pass in inputs at execution time. This enables you to create prepared statements and mitigate SQL injection attacks.
13. Restrict a result set to the specified number of pages
SELECT * FROM sales_invoice lyftstartpage 1 lyftendpage 10
Quickstart Steps
Do you have questions about how to use the platform? Don't worry; we've got you covered. Simply follow the quickstart instructions here.
Questions?
We're always happy to answer any additional questions you may have! Set up a meeting with our data experts.
Last updated