--- [EMAIL PROTECTED] wrote:
> Consider this query:
>
> SELECT a, b FROM t1 UNION SELECT b, a FROM t1 ORDER BY a,b;
>
> Is the query above equalent to:
>
> (1) SELECT a, b FROM t1 UNION SELECT b, a FROM t1 ORDER BY 1,2;
>
> Or is it the same as:
>
> (2) SELECT a, b FROM t1 UNION SELECT b, a FROM t1 ORDER BY 2,1;
Most databases use form (1).
SQLite already leans in this direction anyway, using the first select
in a union for the headings. May as well be consistant.
SQLite version 3.3.15
Enter ".help" for instructions
sqlite> .header on
sqlite> select 3 a union select 4 b;
a
3
4
____________________________________________________________________________________
8:00? 8:25? 8:40? Find a flick in no time
with the Yahoo! Search movie showtime shortcut.
http://tools.search.yahoo.com/shortcuts/#news
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
