27 Sep
2013
27 Sep
'13
6:22 p.m.
indeed. the order by can only be used at the outermost level of a query. A view is merely injected in place.
You migt consider using a table producing function. it might work. martin
On 27 sep. 2013, at 18:08, Khaled Dehdouh khaled.dehdouh@gmail.com wrote:
Please can you help me.
I want to create a view sorted according to attributes like Oracle, my query is as follows:
Create view V1 as Select Name, First_Name, Age from People Oredr by Name;
but Monetdb shows me the following error "CREATE VIEW: ORDER BY not supported."
How should I do to create a sorted view ?. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list