09_SELECT.pdf - CITS1402 Relational Database Management...

This preview shows page 1 - 5 out of 18 pages.

The preview shows page 3 - 5 out of 18 pages.
CITS1402Relational Database Management SystemsVideo 09 — SELECTGordon RoyleDepartment of Mathematics & Statistics
More properties ofSELECTToday’s lecture explores theSELECTstatement in more detailRecall the basic structure:ISELECTChooseswhich columnsare to be returned by the queryIFROMConstructs theinitial tableto pass toWHEREIWHERESelects therowsthat are to be passed toSELECT
Which students are doing CITS1402?Make a list of names of this year’s CITS1402 students.
Make a planIWe need to useStudentandEnrolmentThe names are inStudentand the enrolment details inEnrolmentIJointhe tables based onstudent numberNeed to throw out rows where the student data and enrolment dataare about different studentsIKeeponly rows about students in CITS1402 in 2020.Other rows are irrelevant to this questionIChoosejust thenamesof these studentsQuestion only asked for a list of names

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 18 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
One
Professor
N/A
Tags
Department of Mathematics Statistics, Gordon Royle

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture