Path: utzoo!mnetor!uunet!husc6!ut-sally!ut-emx!lad-shrike!chris
From: chris@AUSTIN.LOCKHEED.COM (Chris Wood)
Newsgroups: comp.databases
Subject: Use of Order By with SQL select
Message-ID: <70@coot.AUSTIN.LOCKHEED.COM>
Date: 11 Jan 88 20:57:05 GMT
Organization: Lockheed Austin Div.
Lines: 14
Keywords: SQL, Select, Order by

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.

2. Can a SELECT clause within a CURSOR definition have
a function reference, or only legal column names?

3. Can we use GROUP BYS and/or HAVINGs in conjunction
with CURSORS?

My source of information is "A Guide to the SQL Standard", 
by C. J. Date.

Chris