Assign2QueryResults

Assign2QueryResults - Assignment 2 Query Results Notice how...

Info icon This 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. 1 2 3 4 5 6 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 7 8 9 10 11 12 13 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
Image of page 1

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern