Having clause is used for filtering grouped data and where clause is used

what is Difference between Having and Where clause?

Question Posted / chandrakala

Answer Posted / chandrakala

Having clause is used for filtering grouped data and where
clause is used for filtering rows.

Is This Answer Correct ?

33 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we need pl sql?

1033

How do you respond to dementia behavior?

1015

What are % type and % rowtype?

1081

What is meant by <> in sql?

1026

Which is the correct statement about truncate and delete?

1169

How do I start pl sql?

995

What does the file extension accdb stand for?

1012

Is sql pronounced sequel or sql?

1336

What are the different types of dbmss?

1054

what are aggregate and scalar functions? : Sql dba

1104

how is exception handling handled in mysql? : Sql dba

1127

What is a database trigger?

1128

How do sql triggers work?

1090

how do you login to mysql using unix shell? : Sql dba

1124

What is on delete set null?

1135