Computer Science
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)
SQL Queries
1 Like
Answer
HAVING
Reason — The HAVING clause is used in SQL queries to place conditions on groups when using the GROUP BY clause.
Answered By
1 Like
Related Questions
…………… is known as range operator in MySQL.
- IN
- DISTINCT
- IS
- BETWEEN
The …………… clause allows sorting of query results by one or more columns.
- ALL
- DISTINCT
- GROUP BY
- ORDER BY
Which of the following is a DDL command?
- SELECT
- ALTER
- INSERT
- UPDATE
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL