SELECT Statements

Features

The following features are supported for the SELECT statement:

1. Using * to select all columns is supported.

  SELECT * FROM Account

2. Column aliases are supported.

  SELECT Name AS MY_Name FROM Account

3. Quoted column names are supported.

  SELECT [Name] FROM Account

4. The =, >, <, >=, <=,

, !=, LIKE, IN, NOT IN are supported in the WHERE Clause.

  SELECT * FROM Account WHERE Industry = 'Floppy Disks';

5. ORDER BY and LIMIT are supported

  SELECT * FROM Account ORDER BY Industry LIMIT 10

6. Parameterized SELECT statements are supported.

  SELECT * FROM Account WHERE Industry = @param

Pseudo-Columns

The RSSBus Salesforce ADO.NET Provider offers some input-only fields in the SELECT Statements. These fields, called pseudo-columns, do not appear as regular columns in the results, yet may be specified as part of the WHERE clause. Pseudo-columns allow access to additional features from Salesforce.

  SELECT * FROM Account WHERE SOQLWhere = 

Limitations

The SQL Syntax for the SELECT statement has the following limitations in this version (when compared to tools like SQL Server):

• Table joins are not supported, so a query can only reference a single table in the FROM clause.
• GROUP BY, HAVING clauses and nested statements are not supported.
• Scalar or aggregation functions are not supported.

Please see the Using Cached Data section for information in using the SELECT statement in offline mode.