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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: recompiling objects after droping and recreating tables
Next Topic: trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 20:28:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.