Assign2QueryResults

Assign2QueryResults - Assignment 2 Query Results Notice how...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment 2 Query Results Notice how using the DISTINCT function eliminates clutter allowing you to better understand what has been returned by the query. This is particuluarly true of questions 7 and 8. 12 3 4 56 with DISTINCT without DISTINCT with DISTINCT without DISTINCT with DISTINCT without DISTINCT with DISTINCT without DISTINCT with DISTINCT without DISTINCT with DISTINCT without DISTINCT order no order no order no order no order no order no order no order no order no order no order no order no 30195 30195 30195 30195 30195 30195 30195 30195 70904 70904 70904 70904 53342 30195 53342 30195 53342 30195 53342 30195 76072 76072 76072 76072 76072 30195 76072 30195 30195 30195 77474 76072 77474 76072 53342 53342 53342 53342 81449 76072 81449 76072 53342 53342 53342 53342 77474 77474 53342 53342 53342 53342 77474 77474 76072 76072 81449 81449 78 9 1 0 1 1 1 2 1 3 14 with DISTINCT without DISTINCT with DISTINCT without DISTINCT order no order no order no order no part no part no part no part no part no part no stockQTY 1402 1402 1402 1402 A25 D1500 A40 D1500 D1800 A30 90 30195 1402 30195 1402 A26 D1800 A41 D1505 D1805 A28 80 4535 1402 4535 1402 A27 D1805 A42 D1806 A40 79 53342 1402 53342 1402 A28 A27 75 70904 30195 70904 30195 A30 A26 56 76072 30195 76072 30195 A31 A32 47 77474 30195 77474 30195 A32 A25 45 81449 30195 81449 30195 A40 A31 33 4535 4535 A41 A42 23 4535 4535 A42 A41 13 4535 4535 53342 53342 53342 53342 53342 53342 70904
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 3

Assign2QueryResults - Assignment 2 Query Results Notice how...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online