MGT268Queries2 (1)

MGT268Queries2 (1) - Order Database Simple Queries Table 3...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Order Database Simple Queries Table 3 The Data in Tables (input) Shows you The Data in a new way (displayed output) Query Definition Query Output Query 1 Simple Queries Table 1 Table 3 Table 5 The Data (input) Shows you The Data in a new way (displayed output) Query Output Query Definition .....just pull attributes from tables.... Stop Here 1967-2002; from http://gradeinflation.com/ Stop Here More Complex Queries - Chains of Queries Table 1 Table 3 Table 5 Query 1 Query 2 Query 3 The Data (input) Shows you the Data in a new way (output) Note the PITIFUL names for these tables and queries. (input & output) (input & output) More Complex Queries - Chains of Queries Table 1 Table 3 Table 5 Query 1 Query 2 Query 3 The Data (input) Shows you the Data in a new way (output) Note the PITIFUL names for these tables and queries. (input & output) (input & output) Get Attributes and Calculate something Sum Up between records and get Attributes Calculate again Running the Last Query runs them all Table 1 Table 3 Table 5 Query 1 Query 2 Query 3 Table 2 The Data (input) Note the PITIFUL names for these tables and queries. Running this one Causes the whole chain to run (It feels like there is only one query) Complex Queries In Each Step, we Calculate something using fields per record OR Summarize something between records Add up Count # of records Find highest or lowest...
View Full Document

Page1 / 28

MGT268Queries2 (1) - Order Database Simple Queries Table 3...

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

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