Can WITH Clause is similar with Function definition in procedural code?

Options
- TRUE
- FALSE


CORRECT ANSWER : TRUE

Discussion Board
WITH Clause

The SQL WITH clause is similar in concept to a function definition in procedural code. In a function, we factor the common code, put it all together at one place and call it as many times as needed in the main program. That’s precisely how we use the WITH clause in SQL – factor out the common subquery, put it all together at one place and call it as many times as needed in the main query.

Prajakta Pandit 02-21-2017 03:20 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement