Ask a Question
  
  
  
Top Posters
Since Sunday
7
6
6
5
5
5
4
4
4
4
4
4
New Topic  
wrote...
Posts: 258
Rep: 0 0
A week ago
Distinguish between the HAVING and WHERE clause.
Source  Download Study Guide
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 17 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 172
A week ago
Sign in or Sign up in seconds to unlock everything on Biology Forums.
The HAVING and WHERE clause differ in that the WHERE clause is used to identify rows that satisfy a stated condition. The HAVING clause is used to identify groups, which have been created by the GROUP BY clause, that satisfy a stated condition. In cases when the WHERE clause and the HAVING clause are both allowed to appear in the same SELECT statement, the WHERE clause is implemented to execute before the HAVING clause.
1
Related Topics
wrote...
A week ago
Thanks
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  91 People Browsing
 203 Signed Up Today
Related Images
 3441
 20297
 376
Your Opinion
Who's your favorite biologist?
Votes: 12