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