Re: [SQL] ORDER BY in definition of views

[Niall Smart]

Michael Ansley wrote:
> 
> Would there be a particular reason to do this?
> 

I like to define views for lookups  (i.e. job titles,
departments, accounts, whatever).  It would be nice
if I could just do a select * from whatever_vw instead
of having to remember to put the order by whatever_name
clause.  Admittedly its no biggie, but it is nice-to-have.


Niall