Path: utzoo!utgpu!water!watmath!clyde!rutgers!rochester!bbn!husc6!amcad!stech!sysop
From: sysop@stech.UUCP (Jan Harrington)
Newsgroups: comp.databases
Subject: Re: Use of Order By with SQL select
Message-ID: <407@stech.UUCP>
Date: 12 Jan 88 13:52:19 GMT
References: <70@coot.AUSTIN.LOCKHEED.COM>
Organization: Scholastech, Inc., Waltham, Mass.
Lines: 26

in article <70@coot.AUSTIN.LOCKHEED.COM>, chris@AUSTIN.LOCKHEED.COM (Chris Wood) says:
> Posted: Mon Jan 11 14:57:05 1988
> 
> 1. Is it legal SQL syntax to include an ORDER BY clause
> with a SELECT clause?  The "SQL Standard" indicates that 
> ORDER BY is only legal within a CURSOR definition.
> 
The answer to this question depends a lot on your implementation.  With
Oracle, ORDER BY is legal with an interactive SELECT, regardless of what
the SQL standard says.  You should check with a given DBMS to be certain.

Sorry, but our Prime Oracle pre-compilers are very buggy and we haven't
yet gotten anything with cursors to run, so I don't have answers for your
other questions.


Jan Harrington, sysop
Scholastech Telecommunications
ihnp4!husc6!amcad!stech!sysop or allegra!stech!sysop

********************************************************************************
	Miscellaneous profundity:

		"No matter where you go, there you are."
				Buckaroo Banzai
********************************************************************************