Hello,
I would appreciate if anybody have an answer for the following.
I need to add a key to SQL view and know that is not possible to do directly.
however, there was a way around as in this code:
CREATE VIEW SCHEMA_NAME/VIEW_NAME as SELECT * FROM (SELECT * FROM TABLE_NAME ORDER BY 1) AS t For some reasons this doesn't work even in interactive SQL (without create view).
I would appreciate any comment for this problem.
Thank you
I would appreciate if anybody have an answer for the following.
I need to add a key to SQL view and know that is not possible to do directly.
however, there was a way around as in this code:
CREATE VIEW SCHEMA_NAME/VIEW_NAME as SELECT * FROM (SELECT * FROM TABLE_NAME ORDER BY 1) AS t For some reasons this doesn't work even in interactive SQL (without create view).
I would appreciate any comment for this problem.
Thank you
Comment