Computer Science
…………… is known as range operator in MySQL.
- IN
- DISTINCT
- IS
- BETWEEN
SQL Queries
2 Likes
Answer
BETWEEN
Reason — The BETWEEN operator is known as the range operator in MySQL because it defines a range of values that the column value must fall within for the condition to be true.
Answered By
2 Likes
Related Questions
The …………… keyword eliminates duplicate rows from the results of a SELECT statement.
- OR
- DISTINCT
- ANY
- ALL
…………… command helps to see the structure of a table/relation.
- Show
- Select
- Describe
- Order by
The …………… clause allows sorting of query results by one or more columns.
- ALL
- DISTINCT
- GROUP BY
- ORDER BY
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)