The simplest retrievals fetch information from one table.
The general form of the simple SELECT statement is:SELECT column-list FROM table_name [WHERE condition];
The column-list specifies which columns to select, and the WHERE condition determines which rows to select. If no WHERE condition is specified, all rows are retrieved from the source table or view.
Examples of Simple Retrieval
Find the format identifiers and their meaning:SELECT format_id, format FROM formats;
Find the name and code for all countries that use Australian dollars (AUD).SELECT country, code FROM countries WHERE currency_code = 'AUD';
How to formulate selection conditions is described in detail in Selecting Specific Rows.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40