DataConnector | ComponentOne
SQL Compliance / SQL Statements
In This Topic
    SQL Statements
    In This Topic

    DataConnector supports multiple SQL queries for different database operations. The table below describes supported SQL statements.

    Name Clauses Examples
    SELECT

    FROM

    		 SELECT * FROM Account
    WHERE SELECT * FROM Account WHERE FirstName <> 'John';
    JOIN

    SELECT  ID, NAME, AMOUNT, DATE
    FROM CUSTOMERS
    INNER JOIN ORDERS
    ON CUSTOMERS.ID = ORDERS.CUSTOMER_ID;

    Similarly, Left Join, Left Outer Join, and Cross Join can be used.

    UNION/UNION ALL SELECT FirstName FROM Account
    UNION
    SELECT CustomerID FROM Customer;
    GROUP BY SELECT * FROM Account GROUP BY Country;
    Aggregate Functions

    SELECT MIN(amount_paid) FROM Accounts;

    Similarly, Max, Sum, Avg, and Count fucntions can be used.

    LIMIT OFFSET SELECT FullName FROM Account LIMIT 10
    ORDER BY SELECT * FROM Account ORDER BY ASC;
    UPDATE Refer CRUD operations topic
    INSERT Refer CRUD operations topic
    DELETE Refer CRUD operations topic