Question:medium

Which SQL clause is used to apply conditions on groups?

Show Hint

WHERE works on rows. HAVING works on groups created using GROUP BY.

Updated On: Jun 25, 2026

WHERE
WITH
SELECT
HAVING

Show Solution

The Correct Option is D

Solution and Explanation

Was this answer helpful?

0

Top Questions on Database Management Systems

What is a primary key in a relational database?
- BITSAT - 2025
- Computer Science
- Database Management Systems
View Solution
Which of the following is NOT a type of database model?
- CUET (UG) - 2025
- Computer Science
- Database Management Systems
View Solution
What does SQL stand for in the context of databases?
- CUET (UG) - 2025
- Computer Science
- Database Management Systems
View Solution
Which of the following is a characteristic of a relational database?
- CUET (UG) - 2025
- Computer Science
- Database Management Systems
View Solution
Want to practice more? Try solving extra ecology questions todayView All Questions

Questions Asked in TS PGECET exam

The Eigenvalues of \(3\times 3\) real matrix A are 1, 2, 3 then \(A^{-1} =\)

TS PGECET - 2026
Linear Algebra

Let \(A=\begin{bmatrix} 1 & 1 & 0 \\ 0 & 1 & 1 \\ 0 & 0 & 1 \end{bmatrix}\). If \(u_1\) and \(u_2\) are column matrices such that \(Au_1 = \begin{bmatrix} 2 \\ 1 \\ 0 \end{bmatrix}\) and \(Au_2 = \begin{bmatrix} 1 \\ 0 \\ 1 \end{bmatrix}\), then \(u_1 - u_2\) is

TS PGECET - 2026
Matrices

Let \(a,b\) and \(c\) be real numbers. Suppose there exist real numbers \(x,y,z\) which are not all zero such that the system of equations \(x = cy + bz\), \(y = cx + az\) and \(z = bx + ay\) has a non-zero solution then \(\left(a+b+c\right)^2 =\)

TS PGECET - 2026
Determinants

For the function \(f(x)=\log x\), the number \(c\) strictly between \(e^2\) and \(e^3\) that satisfies \(f'(c)=\dfrac{f(e^3)-f(e^2)}{e^3-e^2}\) is

TS PGECET - 2026
Calculus