Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


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 ...
 

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 Documentation TOC PREV NEXT INDEX