Home -> Usenet -> comp.databases.oracle -> Repeated columns in an ORDER BY clause?

Repeated columns in an ORDER BY clause?

From: Gautam Bhargava <gautam_at_gautam.engr.sgi.com>
Date: 1996/05/03
Message-ID: <4me475$3u1_at_murrow.corp.sgi.com>#1/1 







Is it legal to repeat column names in an ORDER BY cluase. In other words,
is the following a legal SQL query?
  

     SELECT a, b, c FROM myTable
     ORDER BY a, b, a





Sybase 10.0 flags an error on this.


Oracle 7.2 processes it just fine.



What does the "official" ANSI-standard have to say? 



Thanks.


-- 
Gautam


Received on Fri May 03 1996 - 00:00:00 CEST












Original text of this message