Question

You need to run a complex query with recursive subqueries, but without creating a stored procedure or a function. Which command or clause do you use?

a) RECURSIVE
b) LOOP
c) ITERATE
d) WITH RECURSIVE

Answer 1

The correct command for complex queries with recursive subqueries in SQL is 'WITH RECURSIVE'. This command is used without needing to create a stored procedure or function.

Step-by-step explanation:

If you need to run a complex query with recursive subqueries, but you can't create a stored procedure or a function, the command or clause you should use is d) WITH RECURSIVE. The WITH RECURSIVE clause allows you to perform recursive queries in SQL. It can be used to query hierarchical data or to perform operations that require iteration, such as building hierarchical trees or calculating cumulative sums. For instance, if you're managing a database with employee records and want to retrieve an organizational hierarchy, you might use WITH RECURSIVE to traverse the hierarchy and retrieve all subordinates for a given manager recursively.