# Query Examples with Other Options

This section contains examples of `findbyid`

and `find`

commands using options not used in examples in other sections.

## Return all Documents

`find`

except the table path, the
command returns all documents. The following example returns all documents that are in the
`/data/movies`

table:`find /data/movies `

## Return Limited Number of Documents with Specified Range of IDs

`find /data/movies --fromid movie0000001 --toid movie0000100 --limit 32 `

## Return all Documents with Specified ID

`findbyid /data/movies --id movie0000002 `

## Return Documents Using Projection and Conditions

`find`

operation with a projection and
condition and limits the result to 10
documents:```
find /tbl --c {
"$and":[
{"$eq":{"a.b[0].boolean":false}},
{"$or":[
{"$ne":{"a.c.d":5}},
{"$gt":{"a.b[1].decimal":1}},
{"$lt":{"a.b[1].decimal":10}}
]}
]}
--fields m,a.c.e --limit 10
```

`m`

and `a.c.e`

. The condition
is the following
expression:`(a.b.[0].boolean == false && (a.c.d != 5 || a.b[1].decimal > 1 || a.b[1].decimal < 10))`

## Returns Documents in Specified Order

```
find /tbl --c {
"$and":[
{"$eq":{"a.b[0].boolean":false}},
{"$or":[
{"$ne":{"a.c.d":5}},
{"$gt":{"a.b[1].decimal":1}},
{"$lt":{"a.b[1].decimal":10}}
]}
]}
--fields m,a.c.e
--orderby m,a.c.e:desc
--limit 10
```