Order BY Cluase on View
This is a discussion on Order BY Cluase on View within the Informix forums, part of the Database Server Software category; --> Hi I have question: Can I use Order By Clause on View? Ex: Table Name: XXX View: CREATE VIEW ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:03 PM
| ||||
| ||||
 Order BY Cluase on View Hi I have question: Can I use Order By Clause on View? Ex: Table Name: XXX View: CREATE VIEW YYY "Select * from XXX" I want to use Order By on YYY Select * from YYY order by <<Column Name>> Does it work??? Thx In adv sending to informix-list      |
|
04-19-2008, 08:03 PM
| ||||
| ||||
| Re: Order BY Cluase on View YES - you can use order by in select clause on view. You cannot use ORDER BY clause in CREATE VIEW statement (prior to version 9.40). Gorazd "KchittiBhooma,NarsaReddy" <kchittin@ks2.stph.net> wrote in message news:bm5m4a$tdh$1@terabinaries.xmission.com... > > Hi > > I have question: > Can I use Order By Clause on View? > Ex: Table Name: XXX > View: CREATE VIEW YYY "Select * from XXX" > I want to use Order By on YYY > Select * from YYY order by <<Column Name>> > Does it work??? > > Thx > In adv > > sending to informix-list |
Linear Mode
