Home » SQL & PL/SQL » SQL & PL/SQL » Select/Order By Question
Select/Order By Question [message #408] Mon, 11 February 2002 05:49 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
Must I include the "Order By" field in the "Select" Statement ?
Example: Select fld1, fld2 From table1 Order By fld3.
If the above is correct, is this something specfic to Oracle ? I get an error trying to perform this same SQL statement against a DB2 tbale.

Thanks
David
Re: Select/Order By Question [message #410 is a reply to message #408] Mon, 11 February 2002 06:37 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
in oracle, you need not specify order by column in select list of columns. i have no idea about db2.
Previous Topic: recompiling objects after droping and recreating tables
Next Topic: trigger
Goto Forum:
  


Current Time: Mon Aug 10 04:03:55 CDT 2020