Sales Analytics
  • Sales Analytics
    • Accelo
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Act!Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Aftershiptracking
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Agilecrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Android
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Babelforce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Brandwatch
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Bullhorn
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Capsule CRM
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Centriccrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Closeio
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Clubhouse
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Clubspeed
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Copper
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Coppercrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Drip
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Dynamics 365 Sales
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Eventbrite
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Freshsales
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Gorgias
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Grafana
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Harvest
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Ieyasu
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Insightly
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Launchdarkly
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Lead Desk
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Liondesk
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Logikura
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Mattermark
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Myob Advanced Business
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Netsuite Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Ontraport
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Opsgenie
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Oracle Sales Cloud
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Paymo
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipedrive Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipedrive
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipeline Deals
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Pipeliner
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Repairshopr
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sage Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Salesforce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sap Fieldglass
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sap Hybris C4C
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Shipengine
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Streak
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Sugar Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Suite Crm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Taxrates
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Teamgate
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Unified
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Veeva
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zoho Commerce
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zoho Expense
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
    • Zohocrm
      • Connection Steps
      • Destinations
      • Prerequisite
      • Data Model
        • ERD
        • Tables
        • Views
      • Driver Framework
        • Connecting from Code
        • Connection String
        • Installation
        • Querying Data
        • SQL Standard
        • System Methods
        • System Tables
Powered by GitBook
On this page

Last updated 1 year ago

Select Statements

The driver for 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

  1. Return all columns:

  2. Rename a column:

  3. Cast a column's data as a different data type:

  4. Search data:

  5. Return the number of items matching the query criteria:

  6. Return the number of unique items matching the query criteria:

  7. Return the unique items matching the query criteria:

  8. Summarize data:

  9. Retrieve data from multiple tables.

  10. Sort a result set in ascending order:

  11. Restrict a result set to the specified number of rows:

  12. 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

Questions?

Do you have questions about how to use the platform? Don't worry; we've got you covered. Simply follow the quickstart instructions .

We're always happy to answer any additional questions you may have!

SELECT * FROM employee;

SELECT [age] AS MY_Age FROM address;

SELECT CAST(mobile AS VARCHAR) AS Str_Mobile FROM customer;

SELECT * FROM customer WHERE company_name = 'lyftrondata';

SELECT COUNT(*) AS TotolRows FROM customer;

SELECT COUNT(DISTINCT name) FROM customer;

SELECT DISTINCT name FROM customer;

SELECT priority, MAX(subscriptions) FROM customer GROUP BY subscriptions;

SELECT c.name, a.street FROM customer c INNER JOIN address a ON c.customer_id = a.customer_id

SELECT customer_id, subscriptions FROM customer ORDER BY subscriptions ASC

SELECT customer_id, subscriptions FROM customer LIMIT 10

SELECT * FROM incident WHERE category = @param

  1. Sales Analytics
  2. Babelforce
  3. Driver Framework

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.

PreviousQuerying DataNextSystem Methods
  • Select Statements
  • SELECT Syntax
  • Examples
  • Quickstart Steps
  • Questions?
SELECT {  [ TOP <numeric_literal> | DISTINCT ]  {    *| {<expression> [ [ AS ] <column_reference> ]        | { <table_name> | <correlation_name> } .*      } [ , ... ]}  [ INTO csv:// [ filename= ] <file_path> [ ;delimiter=tab ] ]  {    FROM <table_reference> [[ AS ] <identifier> ]  } [ , ... ]  [ [       INNER | { { LEFT | RIGHT | FULL } [ OUTER ] }    ] JOIN <table_reference> [ ON <search_condition> ] [ [ AS ] <identifier> ]  ] [ ... ]  [ WHERE <search_condition> ]  [ GROUP BY <column_reference> [ , ... ]  [ HAVING <search_condition> ]  [ UNION [ ALL ] <select_statement> ]  [    ORDER BY    <column_reference> [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]  ]  [    LIMIT <expression>    [      { OFFSET | , }      <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> {{= | > | < | >= | <= | <> | != | LIKE | NOT LIKE | IN | NOT IN | IS NULL | IS NOT NULL | AND | OR | CONTAINS | BETWEEN } [ <expression> ]  }} [ {{ AND | OR }} ... ]
Lyftrondata
Babelforce
here
Set up a meeting with our data experts.