What is the question?

Range Query is a term used in database management that describes the lower and upper limits to search the information that the database contains. In fact, the question is common practice for using a database that contains information for the company, organization or other information purposes. In the event that the doctor's office wants to send a postcard to the mail to patients who are payable for annual inspection, the database administrator would use the question to identify the records that fall into the criteria. A lower range may be patients who were the last in the office 25. May in the year before the last. The upper range would be patients who were the last in the 25th May of the previous year. The variable range may vary from searching to search. However, what all searches in common is that is that, database manager, or a person using a database to find information, does not know how many records or files fall within the scope.

For example, a company that sells widgets can monitor the amount of each purchase for each client's record in its database. So when Susie Q in January made a purchase of $ 4,000 (USD), $ 2,000 in March, $ 3,500 in June and another $ 4,000 in October, all these amounts of purchase are recorded in the SUSIA Q record in the database. If the company wants to launch a marketing campaign that rewards loyal customers, it can use a question for a range of database for customers who have purchased more than $ 12,000 from widgets last year.

For this query they would enter $ 12,000 in the lower end of the query on range and $ 12 001 $+ in the top search range field. Another variable would be the data range of the year. Returned results would include a Susie Q.

record

Another instance where the question about the assortment would fit is if the company is looking for customers who have ordered at least four times a year. Question to reach for the amount of order amounts should the lower conEC 4 and upper end 5+. Another variable would be data, so the question about the extent of one year would be included in the database search criteria.

IN OTHER LANGUAGES

Was this article helpful? Thanks for the feedback Thanks for the feedback

How can we help? How can we help?