SP09-Feb05-Lec03-summary-MIS310

SP09-Feb05-Lec03-summary-MIS310 - MIS310-DUTTA Classnotes...

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

View Full Document Right Arrow Icon
MIS310-DUTTA Classnotes, Lecture 03, Feb05-2009 Lecture02 Summary o Self referencing tables, how to set up referential integrity o Basic SQL retrieval commands o SELECT, FROM, WHERE clauses and their syntax o Single table retrievals, cutting horizontally and vertically o Removing duplicated from retrieved answers o Wild card matching o Date functions PLEASE OPEN NORTHWIND database List the First and Last Names of All Seniors List the Names of Products that have been discontinued SELECT Productname FROM Products WHERE Discontinued =Yes; List the First and Last Names of all faculty in the Finance department List the names of Products for which the current inventory level is lower than the reorder level SELECT Productname, Unitsinstock, Reorderlevel FROM Products WHERE Unitsinstock<reorderlevel; List the first and last names of faculty who do not have supervisors. List the Name and Country of suppliers who have Home pages on the Web SELECT Companyname, Country FROM Suppliers WHERE Homepage is NOT NULL;
Background image of page 1

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

View Full Document Right Arrow Icon
List the first and last names of all professors who have taught Corporate Finance. (aliasing)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 5

SP09-Feb05-Lec03-summary-MIS310 - MIS310-DUTTA Classnotes...

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

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