Monday, February 13, 2012

Querying A Database

What sort of information has the query selected?
Any product that has a price that is $10.00


What sort of information has this second query selected?
Any product that has a price that is $20.00 or more. ( I did this by saying >19)

Describe the type of information these queries are selecting.

1. This query has selected any of the products with a recorder level of 10.

 2.  This query has selected any of the products with any recorder level. This is done through not putting a particular amount into the criteria section of the query.

No comments:

Post a Comment