Finding Records

You can easily find records in Standard with exact match or using parameters and limits. Let's continue with the vehicle standard.

Format

To find exact matching records, we use a create query without the '+'.

[std_name] (const1, const2, [...])

To find using parameters...

[std_name] <const1 val, const2 val, [...]>

When finding with parameters, you can add a limit!

[std_name] <const1 val, const2 val, [...], LIMIT 5>

[vehicle] ("VINNUM", "Honda", "Accord")

This query will return one record that matches those parameters. To check if there is more than one record, we can run count with this query...

count [vehicle] ("VINNUM", "Honda", "Accord")

To find and count all Honda vehicles, we can run...

[vehicle] <make "Honda">

#Count all Hondas in vehicle table
count [vehicle] <make "Honda">

Now if we want to find only five Honda vehicles we can run:

[vehicle] <make "Honda", LIMIT 5>

#Get even more specific
[vehicle] <make "Honda", model "Accord", LIMIT 5>