CourseNotes
Published on CourseNotes (https://course-notes.org)

Home > PT 2520 Unit 7

PT 2520 Unit 7

Subject: 
Art History [1]
Rating: 
0
No votes yet
Tags: 
SQL keywords [2]
Data management [3]
SQL [4]
Select [5]
Join [6]
From [7]
Having [8]
Insert [9]
Where [10]
Update [11]
view [12]
Database trigger [13]

PT2520 Clarence Gross 2/9/12 Homework A scalar function operates on one row at a time. True And aggregate function works on multiple rows a time. True Whenever you have an aggregate function in a query criteria, you must use the HAVING keyword. False Any column in a SELECT that contains an aggregate function, but that is not a part of aggregate function, must be addressed in a GROUP BY clause. True An INNER JOIN returns all the records in the joined tables. False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer False There is no error of the following SQL statement: SELECT CustomerCity, Count (CustomerKey) FROM Customer GROUP BY CustomerCity WHERE Count(CustomerCity) > 20 True

Source URL:https://course-notes.org/art_history/premium/pt_2520_unit_7#comment-0

Links
[1] https://course-notes.org/subject/art_history [2] https://course-notes.org/taxonomy/term/1052532 [3] https://course-notes.org/taxonomy/term/1051064 [4] https://course-notes.org/taxonomy/term/1052505 [5] https://course-notes.org/taxonomy/term/1052533 [6] https://course-notes.org/taxonomy/term/1052534 [7] https://course-notes.org/taxonomy/term/1052535 [8] https://course-notes.org/taxonomy/term/1052536 [9] https://course-notes.org/taxonomy/term/1052537 [10] https://course-notes.org/taxonomy/term/1052538 [11] https://course-notes.org/taxonomy/term/1052539 [12] https://course-notes.org/tag_your_content/view [13] https://course-notes.org/taxonomy/term/1052540