Ask questions which are clear, concise and easy to understand.
Ask QuestionPosted by Njan Mahaan 7 years, 3 months ago
- 0 answers
Posted by Pradeep Yadav 7 years, 3 months ago
- 0 answers
Posted by Tanishqua Bhargawa 7 years, 3 months ago
- 0 answers
Posted by Manvendra Singh 7 years, 3 months ago
- 1 answers
Arpit Raj 7 years, 2 months ago
Posted by Preeti Nagra 7 years, 3 months ago
- 0 answers
Posted by Anmol Singh 7 years, 3 months ago
- 0 answers
Posted by Manvendra Singh 7 years, 3 months ago
- 1 answers
Preeti Nagra 7 years, 3 months ago
Posted by Tabrej Khan 4 years, 8 months ago
- 1 answers
Sia ? 4 years, 8 months ago
- The WHERE clause is used in the selection of rows according to given conditions whereas the HAVING clause is used in column operations and is applied to aggregated rows or groups.
- If GROUP BY is used then it is executed after the WHERE clause is executed in the query. It means it selects the rows before grouping is done or aggregate calculations are performed. Thatswhy, WHERE clause is also called Pre-filter. But, GROUP BY is executed before the execution of the HAVING clause. It means it selects the rows after aggregate calculations are performed. Thatswhy, HAVING clause is also called as Post-filter.
- We cannot use the HAVING clause without SELECT statement whereas the WHERE clause can be used with SELECT, UPDATE, DELETE, etc.
- WE can use aggregate functions like sum, min, max, avg, etc with the HAVING clause but they can never be used with WHERE clause.
- HAVING clause is generally used with the GROUP BY. If you use the HAVING clause without GROUP BY then also it can refer to any column but it won't be used while performing the query unlike WHERE clause.
Posted by Pankaj Gupta 7 years, 3 months ago
- 2 answers
Lovepreet Singh 7 years, 3 months ago
Posted by Sunny Kumar 7 years, 3 months ago
- 0 answers
Posted by Ritika Sharma 7 years, 3 months ago
- 0 answers
Posted by Archana Singh 7 years, 3 months ago
- 0 answers
Posted by Vishwajeet Singh 7 years, 3 months ago
- 1 answers
Posted by Ranbir Trikha 7 years, 3 months ago
- 0 answers
Posted by Aaruhi Rawat 7 years, 4 months ago
- 1 answers
Posted by Gyanendra Chaudhary 7 years, 4 months ago
- 1 answers
Nuke 7 years, 4 months ago
Posted by B R 7 years, 4 months ago
- 0 answers
Posted by Khushi Jain 7 years, 4 months ago
- 0 answers
Posted by Vivek Kumar 7 years, 4 months ago
- 1 answers
Posted by Sudarshan Bhatt 7 years, 4 months ago
- 0 answers
Posted by Tushar Soni 7 years, 4 months ago
- 0 answers
Posted by Himanshu Tariyal 7 years, 4 months ago
- 0 answers
Posted by Abhishek Marvolo 7 years, 4 months ago
- 1 answers
Sia ? 4 years, 8 months ago
Both / and % are two different operators used in Java. These operators are mathematical operators and both have different uses. / Only perform the division operation in mathematics and returns results as the quotient, while % is known as modulus. / divides and returns the answer.
Posted by Anchal Bhardwaj 7 years, 4 months ago
- 0 answers
Posted by Daanish Anwar 7 years, 4 months ago
- 1 answers
Sia ? 4 years, 8 months ago
Posted by Sanjana Chawla 7 years, 4 months ago
- 1 answers
Posted by Ranbir Trikha 7 years, 4 months ago
- 1 answers
Diksha Gupta 7 years, 4 months ago
Posted by Aashish Bhanushali 7 years, 4 months ago
- 0 answers

myCBSEguide
Trusted by 1 Crore+ Students

Test Generator
Create papers online. It's FREE.

CUET Mock Tests
75,000+ questions to practice only on myCBSEguide app
myCBSEguide
Arpit Raj 7 years, 2 months ago
0Thank You