A common table expression can be thought of as a temporary result set that is defined within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement.
Syntax
WITH expression_name [ ( column_name [,...n] ) ]
AS
( <Your Query> )
Syntax
WITH expression_name [ ( column_name [,...n] ) ]
AS
( <Your Query> )
No comments:
Post a Comment