Create Sorted View in monetdb
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 O**redr by Name**;*
but Monetdb shows me the following error "CREATE VIEW: ORDER BY not supported."
How should I do to create a sorted view ?.
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
participants (2)
-
Khaled Dehdouh
-
Martin Kersten