nigelc@cognos.UUCP (Nigel Campbell) (10/25/90)
What rule/standard is there that states that a record selection
expression (in a view or trigger) cannot contain a sorted-clause.
define view emp of e in employees ... etc etc ...
sorted by e.emp_no
e.emp_no
e.emp_name ;
Rdb/Vms is a database that supports such a feature as well as a
first-n clause which allows one to restrict the number of rows
( a frequent question I see on the net).--
Nigel Campbell Voice: (613) 783-6828 P.O. Box 9707
Cognos Incorporated FAX: (613) 738-0002 3755 Riverside Dr.
uucp: nigelc@cognos.uucp || uunet!mitel!cunews!cognos!nigelc Ottawa, Ontario
CANADA K1G 3Z4