Question

What is the name of a statement written to retrieve specific data from a table?
field
record
query
command

Answer 1

query. An example of extracting data from a MySQL database could be
```
SELECT * FROM sales WHERE cost > 100;
```

Answer 2

By the way, "sales" is a table, and "cost" is a field inside table, which might look like this:


When choosing between different technical terms, it is relatively easy to google the meaning/definition of each and hence find your answer in a couple of minutes.