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 AcctName AS MY_AcctName FROM Account

3. Quoted column names are supported.
   

   SELECT [AcctName] FROM Account

4. The following operators are supported in the WHERE clause: =, >, <, >=, <=, <>, !=, LIKE, IS, IS NOT.
   

   SELECT * FROM Account WHERE acctName = 'Checking';

5. COUNT is supported.
   

   SELECT COUNT(Id) FROM Account

6. LIMIT is supported:
   

   SELECT InternalId, AcctName FROM Account LIMIT 10 

7. Parameterized SELECT statements are supported.
   

   SELECT * FROM Account WHERE acctName = @param

Pseudo Columns

Some input-only fields are available in 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. You can use pseudo columns to access additional features from NetSuite.

SELECT * FROM Account WHERE CompanyName = Microsoft

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