× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
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 44 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
  1090 People Browsing
 115 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 4423
  
 27502
  
 249
Your Opinion
Where do you get your textbooks?
Votes: 328
Previous poll results: Which 'study break' activity do you find most distracting?