This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: SQL statements used to construct views cannot contain: A) the SELECT clause. B) the FROM clause. ... (Read 30 times)

Pineapplelove6

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
SQL statements used to construct views cannot contain:
 
  A) the SELECT clause.
  B) the FROM clause.
  C) the WHERE clause.
  D) the ORDER BY clause.
  E) the LIKE keyword.

Question 2

Compare and contrast subqueries and joins.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

ilianabrrr

  • Sr. Member
  • ****
  • Posts: 332
Reply #1 on: Jul 7, 2018
Answer to Question 1

D

Answer to Question 2

Subqueries and joins are both used to process data for queries that require data from multiple tables. Subqueries involve embedding a second query within the WHERE clause of the first query. Many levels of subqueries can exist. Joins involve combining the rows of multiple tables into a single relation whose rows contain the data from all the tables that are joined. This new relation can then be processed by the other clauses of the SELECT query. One notable issue with subqueries is that only data from a single table may appear in the result that is returned by the query. One notable issue with joins is that any unmatched rows in either table will not appear in the result that is returned by the query.


Pineapplelove6

  • Hero Member
  • *****
  • Posts: 560
Reply #2 on: Jul 7, 2018
TY


ilianabrrr

  • Sr. Member
  • ****
  • Posts: 332
Reply #3 on: Jul 7, 2018
Happy to Help


« previous next »
 

Did you know?

Cyanide works by making the human body unable to use oxygen.

Did you know?

Aspirin may benefit 11 different cancers, including those of the colon, pancreas, lungs, prostate, breasts, and leukemia.

Did you know?

Over time, chronic hepatitis B virus and hepatitis C virus infections can progress to advanced liver disease, liver failure, and hepatocellular carcinoma. Unlike other forms, more than 80% of hepatitis C infections become chronic and lead to liver disease. When combined with hepatitis B, hepatitis C now accounts for 75% percent of all cases of liver disease around the world. Liver failure caused by hepatitis C is now leading cause of liver transplants in the United States.

Did you know?

More than 50% of American adults have oral herpes, which is commonly known as "cold sores" or "fever blisters." The herpes virus can be active on the skin surface without showing any signs or causing any symptoms.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Aerial and close-up views of a large biodiversity experiment in Cedar Creek, Minnesota. Each of the Aerial and close-up views of a large biodiversity experiment in Cedar Creek, Minnesota. Each of the
Selected skeletal muscles and the Achilles tendon (anterior and posterior views). Selected skeletal muscles and the Achilles tendon (anterior and posterior views).
Views of the Milky Way’s Central Regions Views of the Milky Way’s Central Regions
Utagawa Hiroshige (Ando), Moon Pine, Ueno, No. 89 from One Hundred Famous Views of Edo Utagawa Hiroshige (Ando), Moon Pine, Ueno, No. 89 from One Hundred Famous Views of Edo
Select the proper adapter for the compression gauge. The threads on the adapter should match those ... Select the proper adapter for the compression gauge. The threads on the adapter should match those ...
How does PCA reduce the dimension of a statistical problem? How do you select the reduced ... How does PCA reduce the dimension of a statistical problem? How do you select the reduced ...
Video: Summary of female reproductive cycle days 1-28

For a complete list of videos, visit our video library