www.mimer.com/developer

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  CITY,NAME
 FROM    HOTEL;

Results:

CITY	NAME
STOCKHOLM	LAPONIA
UPPSALA	SKYLINE
STOCKHOLM	ST. GEORGE
London	Winston
COPENHAGEN	WINSTON
GOTHENBURG	WINSTON

Quick Select

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

 SELECT * FROM table ...
 

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

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se