1.

What Is The Difference Between A "where" Clause And A "having" Clause?

Answer»

"Where" is a kind of RESTRICTION STATEMENT. You use where clause to restrict all the data from DB. Where clause is using before RESULT retrieving. But Having clause is using after retrieving the data. Having clause is a kind of FILTERING COMMAND.

"Where" is a kind of restriction statement. You use where clause to restrict all the data from DB. Where clause is using before result retrieving. But Having clause is using after retrieving the data. Having clause is a kind of filtering command.



Discussion

No Comment Found