Question

You are querying a database of manufacturing company suppliers. The column name for supplier identification numbers is supplier_id. What is the correct clause to retrieve only data about the supplier with identification number 85317?

Answer 1

Queries are used to retrieve data from the database

The correct clause to retrieve only data about the supplier with identification number 85317 is WHERE supplier_id = 85317

How to determine the query

The clause is given as:

identification number = 85317

To retrieve data from the database, we make use of the WHERE clause followed by the column name, and the column value

In this case,

supplier_id represents the column name, while 85317 represents the value

Hence, the required clause is

WHERE supplier_id = 85317

Read more about database at:

brainly.com/question/1538272