| 1 |
/* |
| 2 |
https://surrealdb.com/docs/surrealql/statements/select#example-usage |
| 3 |
*/ |
| 4 |
-- Select all person records with IDs between the given range |
| 5 |
SELECT * FROM person:1..1000; |
| 6 |
# Select all records for a particular location, inclusive |
| 7 |
SELECT * FROM temperature:['London', NONE]..=['London', time::now()]; |
| 8 |
-- Select all temperature records with IDs less than a maximum value |
| 9 |
SELECT * FROM temperature:..['London', '2022-08-29T08:09:31']; |
| 10 |
-- Select all temperature records with IDs greater than a minimum value |
| 11 |
SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..; |
| 12 |
-- Select all temperature records with IDs between the specified range |
| 13 |
SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..['London', '2022-08-29T08:09:31']; |