Using Select to Create Amazon SimpleDB Queries
This section describes Select
, a function that takes query
expressions similar to the standard SQL SELECT
statement.
Use the following format for the Select
function.
select
output_list
fromdomain_name
[whereexpression
] [sort_instructions
] [limitlimit
]
The output_list
can be any of the following:
* (all attributes)
itemName() (the item name only)
count(*)
An explicit list of attributes (attribute1,..., attributeN)
Name | Description |
---|---|
domain_name
|
The domain to search. |
expression
|
The match expression. This rest of this section provides examples of how to form select expressions. |
sort_instructions
|
Sorts the results on a single attribute, in ascending or descending order. For information on sorting results, see Sort. |
limit
|
The NoteThe total size of the response cannot exceed 1 MB. Amazon SimpleDB automatically adjusts the number of items returned per page to enforce this limit. For example, even if you ask to retrieve 2500 items, but each individual item is 10 KB in size, the system returns 100 items and an appropriate next token so you can get the next page of results. |
The expression
can be any of the following:
-
<select expression> intersection <select expression>
-
NOT <select expression>
-
(<select expression>)
-
<select expression> or <select expression>
-
<select expression> and <select expression>
-
<simple comparison>
Note
For information on how to use quotes with Amazon SimpleDB, see Select Quoting Rules.