|« PreviousNext »|
|Did this page help you? Yes | No | Tell us about it...|
This section shows simple queries and their results.
To view the source data for the queries, see Sample Query Data Set.
The following table shows some simple queries, how they are interpreted, and the results they return from the sample dataset.
|Retrieves all items where the attribute "Title" equals "The Right Stuff".||1579124585|
Retrieves all items where "Year" is greater than "1985".
Although this looks like a numerical comparison, it is lexicographical. Because the calendar won't change to five digits for nearly 8,000 years, "Year" is not zero padded.
|B000T9886K, B00005JPLW, B000SF3NGK|
Retrieves all items that have at least a 4 star (****) rating.
The prefix comparison is case-sensitive and exact and does not match attributes that only have the "4 star" value, such as item B000T9886K.
|0385333498, 1579124585, 0802131786, B000SF3NGK|
Retrieves all items that have less than 320 pages.
This attribute is zero padded in the data set and the select expression, which allows for proper lexicographical comparison between the strings. Items without this attribute are not considered.