The SQL keyword BETWEEN is used:

Option A: for ranges. - This is the correct answer. The SQL keyword "BETWEEN" is used to specify a range of values. It is typically used in a WHERE clause to retrieve rows with values within a specified range.
Option B: to limit the columns displayed. - This option is incorrect. The "BETWEEN" keyword is not used to limit the columns displayed; it is used for filtering rows based on values within a range.
Option C: as a wildcard. - This option is incorrect. "BETWEEN" is not used as a wildcard. Wildcards in SQL are characters used to substitute for other characters in string matching.
Option D: None of the above is correct. - This option is incorrect because Option A ("for ranges") accurately describes the purpose of the SQL keyword "BETWEEN".
Conclusion:
The SQL keyword "BETWEEN" is used Option A: for ranges. It allows you to specify a range of values to filter rows in a query. Therefore, the correct answer is for ranges.