Order BY Cluase on View

Posted in 2003

KchittiBhooma,NarsaReddy — Fri, 10 Oct 2003 12:15:45 +0530 — source: Usenet: comp.databases.informix

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

↪ replying to KchittiBhooma,NarsaReddy

Gorazd Hribar Rajteri�� — Fri, 10 Oct 2003 12:35:22 +0200 — source: Usenet: comp.databases.informix

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