AP Notes, Outlines, Study Guides, Vocabulary, Practice Exams and more!

view

PT 2520 Unit 7

Subject: 
Art History
Rating: 
0
No votes yet
Tags: 
SQL keywords
Data management
SQL
Select
Join
From
Having
Insert
Where
Update
view
Database trigger

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
Subscribe to RSS - view

Need Help?

We hope your visit has been a productive one. If you're having any problems, or would like to give some feedback, we'd love to hear from you.

For general help, questions, and suggestions, try our dedicated support forums.

If you need to contact the Course-Notes.Org web experience team, please use our contact form.

Need Notes?

While we strive to provide the most comprehensive notes for as many high school textbooks as possible, there are certainly going to be some that we miss. Drop us a note and let us know which textbooks you need. Be sure to include which edition of the textbook you are using! If we see enough demand, we'll do whatever we can to get those notes up on the site for you!