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