Select

HarperDB has robust SELECT support, from simple queries all the way to complex joins with multi-conditions, aggregates, grouping & ordering.

 

All results are returned as JSON object arrays.

 

Query for all records and attributes in the dev.dog table:
SELECT * FROM dev.dog
Query specific columns from all rows in the dev.dog table:
SELECT id, dog_name, age FROM dev.dog
Query for all records and attributes in the dev.dog table ORDERED BY age in ASC order:
SELECT * FROM dev.dog ORDER BY age

*The ORDER BY keyword sorts in ascending order by default. To sort in descending order, use the DESC keyword.