Use SQL's SELECT statement to view information in the database. You can see the values of all fields for an entry or you can see a specified subset.
At its most basic, the syntax for the SELECT statement is as follows:
SELECT <field-name-1>[, <field-name-2>] ... FROM tablename
field-name represents a column or columns in tablename.
tablename is the name of the database table.
For example, the statement
SELECT C_FIRST_NAME, C_LAST_NAME FROM CUSTOMER
returns the first and last names of customers listed in the customer table: