You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a sessio

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a sessio

Post by answerhappygod »

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The variables used in your query are never undefined in your session.Which query can be used?

A. SELECT &&col1, &&col2 FROM &table WHERE &&condition = &&cond;
B. SELECT &col1, &col2 FROM &&table WHERE &condition;
C. SELECT &col1, &col2 FROM ג€&tableג€ WHERE &condition;
D. SELECT ג€˜&&col1ג€™, ג€˜&&col2ג€™ FROM &table WHERE ג€˜&&conditionג€™ = ג€˜&condג€™; E. SELECT &&col1, &&col2 FROM &table WHERE &&condition;
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply