Result Order

---

The columns in the result table are ordered as they are written in the SELECT statement, irrespective of the ordering in the source table. For example:

 SELECT format, format_id
    FROM formats;

Returns:

FORMAT	FORMAT_ID
Audio CD	1
Cassette	2
DVD Audio	3
Vinyl	4
Audio Cassette	5
Audio CD	6
Hardcover	7
Paperback	8
DVD Video	9
Video	10

Quick Select

A shorthand form for selecting all columns from a table is:

 SELECT * FROM table_name ...
 

In this case, the columns in the result table are ordered as they are defined in the source table.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se