wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

With the help of an example, briefly state the meaning of parameter queries.

Open in App
Solution

A Parameter Query is a query where for selecting a set of records, the user is asked to enter parameters or criteria through an input box. A Parameter Query is useful when the same query is to be repeated with different criteria.
In short, it implies the execution of same set of queries with different requirements.

For example, the same set of queries is required for different accounts code, while extracting the information to prepare ledger.
Let us consider the given below SQL statement.
PARAMETERS Accounts Name Text (145)
SELECT Name
FROM Accounts
WHERE Code = Account No
In the above query, PARAMETERS clause is used to represent the variable Account No. This SQL statement requires the user to provide the different values of Account No.


flag
Suggest Corrections
thumbs-up
1
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Database Structuring
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon