SQL Questions

Q:

Which of the following statements is true concerning subqueries?

A) Does not start with the word SELECT. B) Involves the use of an inner and outer query.
C) Cannot return the same result as a query that is not a subquery. D) All of the above
 
Answer & Explanation Answer: B) Involves the use of an inner and outer query.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

0 1579
Q:

What UNION does in SQL?

Answer

In SQL, UNION  merges the contents of two structurally-compatible tables into a single combined table.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL
Job Role: IT Trainer , Database Administration

0 1297