SQL+Practical+Workbook

SQL+Practical+Workbook - Practical Workbook 2 Using SQL...

Info iconThis preview shows pages 1–3. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Practical Workbook 2 Using SQL Hatherly, D., Witney, N. (1999). Revised Blackmore, K. (2005) Using SQL V2 i Using SQL Table of Contents Using Microsoft Access............................................................................1 Opening a database......................................................................................1 Entering new SQL SELECT statements......................................................1 Displaying or running saved SQL SELECT statements..............................1 Saving an SQL SELECT statement ............................................................1 How to use these exercises...........................................................................2 Section 1 - choosing rows and attributes, sorting.................................3 Displaying all attributes...............................................................................3 Choosing the attributes to be displayed.......................................................3 Choosing the rows to be displayed...............................................................4 NULL values................................................................................................5 Choosing the rows to display using more complex conditions....................6 Other operators - LIKE, BETWEEN and IN...............................................7 Sorting results...............................................................................................9 The DISTINCT keyword...........................................................................10 Notes on layout..............................................................................................10 Problems.....................................................................................................12 Section 2 - Retrieving information from several tables.......................13 Combining two tables................................................................................13 Qualifying to avoid problems with repeated attribute names....................15 Combining more than two tables...............................................................17 Notes on layout..........................................................................................19 Problems.....................................................................................................19 Section 3 - Aggregation and Grouping..................................................20 Examples of aggregation................................................................................20 Examples of grouping....................................................................................22 Typical exam question...............................................................................24 Using ORDER BY with aggregate functions.............................................24 The HAVING subclause............................................................................25 Summary....................................................................................................26Summary....
View Full Document

Page1 / 51

SQL+Practical+Workbook - Practical Workbook 2 Using SQL...

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