Note the following:
-
The TOP and FROM clauses can be added to refine results (see Examples).
-
Do not remove any of the base elements of the query; add clauses, column names, and row values as needed.
-
Separate two or more column names with a comma and space and ensure they are entered before FROM.
-
Enclose column names and parameters in double quotes (“”); for example "
aid" and "eid"='1'AND"show_entity_names"='5' -
Enclose values values in single quotes (‘’); for example, "
aid"='2'. -
To return multiple entity, attribute, or project IDs, add the values with a space between each. For example, WHERE "eid"='1 2 3'
-
If you do not specify column names and rows, all available columns display for all rows. For information about columns returned, see Column Names.