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

explain advantages of myisam over innodb? : Sql dba

1069

What is the difference between alter trigger and drop trigger statements?

1109

what is the difference between where clause and having clause? : Sql dba

1000

how to install mysql? : Sql dba

1110

describe transaction-safe table types in mysql : sql dba

1006

What is the use of triggers?

1037

Is oracle and sql same?

1013

What is oracle pl sql developer?

984

How do you declare a variable in pl sql?

1029

which tcp/ip port does sql server run on? : Sql dba

1026

Why are sql stored procedures used?

1056

What is the purpose of normalization?

1042

Is natural join same as inner join?

943

What is group function in sql?

1024

What is sql key?

995