Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

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
Mimer SQL User's Manual TOC PREV NEXT INDEX