No products in the cart.

Write difference between where clause and …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Write difference between where clause and having clause

Posted by Tabrej Khan 3 years, 5 months ago

CBSE > Class 12 > Informatics Practices

1 answers

Sia ? 3 years, 5 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.

ANSWER

http://mycbseguide.com/examin8/

Related Questions

Consider a given series,M1 write a program in python pandas to create the series

Posted by Martina Sangchoju 9 months, 3 weeks ago

CBSE > Class 12 > Informatics Practices

2 answers

Display the details of all the employees whose value is null

Posted by Yashika Kakkar 6 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

Select round(6.5675,2);

Posted by Simran Batra 5 months ago

CBSE > Class 12 > Informatics Practices

0 answers

Write a program that generates the table of a input number using for loop

Posted by Siya Vishwakarma 7 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

All data types of MySQL with example

Posted by Prapti Dubey 6 months ago

CBSE > Class 12 > Informatics Practices

0 answers

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

Don't post personal information, mobile numbers and other details.
Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

Posted by Honey Hanisha 9 months, 3 weeks ago

CBSE > Class 12 > Informatics Practices

0 answers

Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

Posted by Sejal Gupta 6 months, 2 weeks ago

CBSE > Class 12 > Informatics Practices

0 answers

Founder of python

Posted by Parth Chaudhary 9 months, 1 week ago

CBSE > Class 12 > Informatics Practices

2 answers

what are aggregate function inSQL? Name any two

Posted by Arifa Meharun 4 months ago

CBSE > Class 12 > Informatics Practices

0 answers

List down the average of phone number what is the coding I couldn't remember

Posted by Akib Chowdhury 5 months, 4 weeks ago

CBSE > Class 12 > Informatics Practices

1 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Google Play

Download myCBSEguide App