State various uses of a subquery.
What will be an ideal response?
Get result from a SELECT query and use it in another statement.
Create a table based on another existing table.
Insert rows into a table from another table.
Delete or update rows.
Create queries with subqueries instead of joins.
Correlated subqueries.
MERGE statement
Computer Science & Information Technology
You might also like to view...
Which of the following statements best describes strategic risk?
A) The risk arising from adverse business decisions B) The risk arising from negative public opinion C) The risk arising from problems with service or product delivery D) The risk of loss resulting from inadequate or failed internal processes, people, or systems
Computer Science & Information Technology
_____ risks cannot be managed directly.
a. Exposure b. Unknown c. Unsystematic d. Model
Computer Science & Information Technology