Use the UDT constructed in Exercise 14.8 to answer the following query: List the names of al l projects that have more than ?ve members.
What will be an ideal response?
Assume that we have a table, Project,of type ProjectType.
SELECT P.Name
FROM Project P
WHERE count(P->Id) > 5
Computer Science & Information Technology
You might also like to view...
A(n) ____________ compares the values of two expressions.
a. relational operator b. bit wise assessment c. associative operator d. comparative structure
Computer Science & Information Technology
In SQL, the ____ symbol is used as a wildcard to represent any collection of characters.
A. * B. % C. ? D. !
Computer Science & Information Technology