Over the past chapters, we've looked at quite a few different queries. We've seen how to create tables, insert and remove data, filter data based on conditions, and efficiently query data using queries.
Although, these queries are the most common types of queries you will use, sometimes you may want to write more complex queries, especially when working with large datasets. In this section, you will learn new ReQL commands and use RethinkDB's advanced features to run more advanced queries.
We will start by looking at three extremely useful queries.
The most common queries in a database system are read queries, which make use of RethinkDB's filter command or, in case you're using an index, the getAll command. There are a number of query options that can be appended at the end of these queries; these include limiting the number of documents returned, skipping a number of documents, and ordering documents.
The ReQL query language is extremely expressive...
