Refer to the exhibit. How should the WHERE clause be changed to set the city and state values from the configured input parameters?
Refer to the exhibit. How should the WHERE clause be changed to set the city and state values from the configured input parameters?
To set the city and state values from the configured input parameters in SQL, the appropriate syntax is to use bind variables. This can be done using the colon (:) followed by the parameter name. Therefore, the correct WHERE clause change is: WHERE city = :city AND state = :state.
A - correct
A - correct
ChatGPT: Therefore, the correct way to change the WHERE clause to use the configured input parameters would be: A. WHERE city = :city AND state = :state