Database Reference
In-Depth Information
How do I?
Review the Named Section(s) in Appendix B
Retrieve only certain columns?
1. SELECT
2. Column or Expression List (SELECT clause)
(Type the list of columns in the SELECT clause.)
358
Revoke a privilege?
REVOKE
Select all columns?
1. SELECT
2. Column or Expression List (SELECT clause)
(Type * in the SELECT clause.)
Select all rows?
SELECT
(Omit the WHERE clause.)
Select only certain columns?
1. SELECT
2. Column or Expression List (SELECT clause)
(Type the list of columns in the SELECT clause.)
Select only certain rows?
1. SELECT
2. Conditions
(Use a WHERE clause.)
Sort query results?
SELECT
(Use an ORDER BY clause.)
Specify a foreign key?
Integrity
(Use a FOREIGN KEY clause in an ALTER TABLE
command.)
Specify a primary key?
Integrity
(Use a PRIMARY KEY clause in an ALTER TABLE
command.)
Specify a privilege?
GRANT
Specify integrity?
Integrity
(Use a CHECK clause in an ALTER TABLE command.)
Specify legal values?
Integrity
(Use a CHECK clause in an ALTER TABLE command.)
Update rows?
UPDATE
Use a computed ield?
1. SELECT
2. Column or Expression List (SELECT clause)
(Enter a calculation in the query.)
Use a compound condition in a
Conditions
query?
Use a compound condition?
1. SELECT
2. Conditions
(Use simple conditions connected by AND, OR, or NOT in a
WHERE clause.)
Use a condition in a query?
1. SELECT
2. Conditions
(Use a WHERE clause.)
Use a subquery?
Subqueries
Use a wildcard?
1. SELECT
2. Conditions
(Use LIKE and a wildcard in a WHERE clause.)
Use UNION operation?
UNION
(Connect two SELECT commands with UNION.)
FIGURE C-1
How do I? reference
(continued)
Search WWH ::




Custom Search