• By Shree Khanal
  • 6/3/2014
  • 0

Summary CTE can be used to ›--> Create a recursive query. ›--> Substitute for a view when the general use of a view is not required; when you do not have to store the definition in metadata. -->› Enable grouping by a column that is derived from a scalar subselect or a function which is not deterministic or has external access. ›--> Reference the resulting table multiple times in the same statement.

Continue Reading
Page: 1 of 1


StackOverflow RSS

Tag Cloud