The 2016 Hitchhikers Reference Guide to SQL by Marcus Vannini

Author:Marcus Vannini [Vannini, Marcus]
Language: eng
Format: epub, azw3, mobi
Published: 2016-02-03T23:00:00+00:00

Appendix II – MORE SELECT Examples

All statements use the following tables and field names. All items are of string type, except as noted:

Select statements enable us to view tables or selected records and selected fields in a table or tables.

To show all fields in a table, all Customers:

SELECT * FROM tblCustomers

To show only particular fields from a table, but all Customers:

SELECT FirstName, LastName FROM tblCustomers

To show only particular fields from a table, one customer:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.