SQL for the System Administrator
Viewing Table Information
To show the data for a single column in a table:
select "COLUMN_NAME" from "TABLE_NAME"
To show the data for multiple columns in a table:
select "COLUMN1_NAME", "COLUMN2_NAME", "COLUMN3_NAME"
from "TABLE_NAME"
To show the data for multiple columns in a table where one of the
columns data is limited to a particular value, such as server name, etc:
select "COLUMN1_NAME", "COLUMN2_NAME", "COLUMN3_NAME"
from "TABLE_NAME"
where COLUMN2_NAME = 'string_value' <-- note the use of
single quotes for strings