Part 1- Basics - SQL Select(Part 1 Murach Chapters 3 8 and...

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

View Full Document Right Arrow Icon
SQL Select (Part 1) Murach Chapters 3, 8 and 12
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
DML: Data Manipulation Language SELECT INSERT UPDATE Modifies physical data DELETE Select is also known as DQL (Q for query) Insert, Update and Delete are also known as the Action commands
Background image of page 2
Select Syntax (elementary version) SELECT FROM WHERE ORDER BY Note: SELECT and FROM are mandatory clauses WHERE and ORDER BY are optional Relative sequence of clauses is fixed fields tables row conditions fields
Background image of page 3

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

View Full Document Right Arrow Icon
Show everything in the table SELECT FROM Note: The database engine will display the records in the fastest possible row and column order * tblEmployee
Background image of page 4
Alphabetized list of accountants SELECT FROM WHERE ORDER BY Note 1: No explicit reference to secondary index Note 2: Accountant = accountant = AcCoUnTaNt * tblEmployee JobTitle = 'Accountant' LastName, FirstName
Background image of page 5

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

View Full Document Right Arrow Icon
Annual salaries of accountants SELECT FROM WHERE ORDER BY FirstName, LastName, AnnualSalary tblEmployee JobTitle = 'Accountant' LastName, FirstName
Background image of page 6
Monthly salaries of accountants SELECT FROM WHERE ORDER BY FirstName, LastName, AnnualSalary /12 tblEmployee JobTitle = 'Accountant' LastName, FirstName
Background image of page 7

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

View Full Document Right Arrow Icon
Column Headings SELECT FROM SELECT FROM field AS heading tables FirstName, LastName, AnnualSalary / 12 tblEmployee
Background image of page 8
Column Headings SELECT FROM SELECT FROM field AS heading tables FirstName, LastName, AnnualSalary / 12 AS MonthlySalary tblEmployee
Background image of page 9

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

View Full Document Right Arrow Icon
Column Headings - Special Characters
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 32

Part 1- Basics - SQL Select(Part 1 Murach Chapters 3 8 and...

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

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