Difference between revisions of "Homework 4 - part 2"
From Wikivyuka
m |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 6: | Line 6: | ||
#Group Functions, Try It / Solve It 2, 3 | #Group Functions, Try It / Solve It 2, 3 | ||
#COUNT, DISTINCT, NVL, Try It / Solve It 1, 2 | #COUNT, DISTINCT, NVL, Try It / Solve It 1, 2 | ||
| + | <hr> | ||
| + | Database Programming - Section 5, Practice Guide | ||
| + | |||
| + | #GROUP BY and HAVING Clauses, Try It / Solve It 2a, 2b, 2c, 2d, 5, 6 | ||
| + | #Using ROLLUP and CUBE Operations, and GROUPING SETS Try It / Solve It 1 | ||
| + | #Using SET Operators, Try It / Solve It 2 | ||
<hr> | <hr> | ||
Latest revision as of 12:41, 16 March 2011
Run the following queries in Oracle Application Express. Paste a copy of each query on a Microsoft Word document or notepad text file, save and return to your adjunct via email.
Database Programming - Section 4, Practice Guide
- Review of Joins Try It / Solve It 1a, 1c, 1d, 2b, 2e
- Group Functions, Try It / Solve It 2, 3
- COUNT, DISTINCT, NVL, Try It / Solve It 1, 2
Database Programming - Section 5, Practice Guide
- GROUP BY and HAVING Clauses, Try It / Solve It 2a, 2b, 2c, 2d, 5, 6
- Using ROLLUP and CUBE Operations, and GROUPING SETS Try It / Solve It 1
- Using SET Operators, Try It / Solve It 2
