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 63 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?

In 1864, the first barbiturate (barbituric acid) was synthesized.

Did you know?

According to animal studies, the typical American diet is damaging to the liver and may result in allergies, low energy, digestive problems, and a lack of ability to detoxify harmful substances.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Your chance of developing a kidney stone is 1 in 10. In recent years, approximately 3.7 million people in the United States were diagnosed with a kidney disease.

Did you know?

For pediatric patients, intravenous fluids are the most commonly cited products involved in medication errors that are reported to the USP.

Posterior views of H. erectus, Neandertal, and modern H. sapiens show differences in vault shape. Posterior views of H. erectus, Neandertal, and modern H. sapiens show differences in vault shape.
Views of Alligator and Human Views of Alligator and Human
Select the Preliminary Code(s) Select the Preliminary Code(s)
Views of Earth’s Layered Structure Views of Earth’s Layered Structure
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 ...
Different views of the brain Different views of the brain
Video: Sister chromatids of a metaphase chromosome animation

For a complete list of videos, visit our video library