× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
traggthuyy@gmai traggthuyy@gmai
wrote...
solved
Posts: 304
Rep: 0 0
5 years ago
Distinguish between the HAVING and WHERE clause.
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 45 times
1 Reply

Related Topics

Replies
wrote...
#1
5 years ago
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.
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1137 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 4427
  
 27522
  
 253
Your Opinion
What's your favorite math subject?
Votes: 293
Previous poll results: What's your favorite coffee beverage?