Menu
Amazon SimpleDB
Developer Guide (API Version 2009-04-15)

Range Queries

Amazon SimpleDB enables you to execute more than one comparison against attribute values within the same predicate. This is most commonly used to specify a range of values.

This section shows range queries and their results.

Note

To view the source data for the queries, see Sample Query Data Set.

The following table shows some range queries, how they are interpreted, and the results they return from the sample dataset.

Select Expression Description Result
select * from mydomain where Year > '1975' and Year < '2008' Retrieves all items that have a "Year" value between "1975" and "2008", excluding "1975" and "2008". 1579124585, B000T9886K, B00005JPLW, B000SF3NGK
select * from mydomain where Year between '1975' and '2008' Retrieves all items that have a "Year" value between "1975" and "2008", including "1975" and "2008". 1579124585, B000T9886K, B00005JPLW, B000SF3NGK
select * from mydomain where Rating = '***' or Rating = '*****'

Retrieves all items that have 3 (***) or 5 (*****) star rating

This is a discontiguous range query that consists of two distinct values selected from the range of all possible values for the attribute.

0385333498, B00005JPLW, B000SF3NGK
select * from mydomain where (Year > '1950' and Year < '1960') or Year like '193%' or Year = '2007' Retrieves all items where the "Year" attribute is either between "1950" and "1960", excluding "1950" and "1960", or falls in the nineteen-thirties, or equals "2007". 0385333498, 0802131786, B000T9886K, B00005JPLW