What Is The Difference Between A Having Clause And A Where Clause?

1.	What Is The Difference Between A Having Clause And A Where Clause?
Answer» They SPECIFY a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT STATEMENT. HAVING is TYPICALLY used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is BASICALLY used only with the GROUP BY function in a query whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

Answer»

They SPECIFY a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT STATEMENT. HAVING is TYPICALLY used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is BASICALLY used only with the GROUP BY function in a query whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

They specify a search condition for a group or an aggregate. But the difference is that HAVING can be used only with the SELECT statement. HAVING is typically used in a GROUP BY clause. When GROUP BY is not used, HAVING behaves like a WHERE clause. Having Clause is basically used only with the GROUP BY function in a query whereas WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.

Discussion

No Comment Found

Related InterviewSolutions

What Function Catx Syntax Does?
Mention The Validation Tools Used In Sas?
Explain How You Can Debug And Test Your Sas Program?
In Sas Explain Which Statement Does Not Perform Automatic Conversions In Comparisons?
Explain What Is Pdv?
Explain What Is Data Step?
Explain What Is The Basic Structure Of Sas Programming?
Explain What Is Sas? What Are The Functions Does It Performs?
Name Several Ways To Achieve Efficiency In Your Program.
If Reading A Variable Length File With Fixed Input, How Would You Prevent Sas From Reading The Next Record If The Last Variable Didn't Have A Value?