Q 12. Explain WITH clause in SQL?
Ans : The WITH clause provides a way relationship of defining a temporary relationship whose definition is available only to the query in which the with clause occurs.
SQL applies predicates in the WITH clause after groups have been formed, so aggregate functions may be used.
No comments:
Post a Comment