Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX