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

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

Cancer has been around as long as humankind, but only in the second half of the twentieth century did the number of cancer cases explode.

Did you know?

Of the estimated 2 million heroin users in the United States, 600,000–800,000 are considered hardcore addicts. Heroin addiction is considered to be one of the hardest addictions to recover from.

Did you know?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

The Coronary Arteries and Major Veins of the Heart (Anterior and Inferior Views) The Coronary Arteries and Major Veins of the Heart (Anterior and Inferior Views)
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 ...
Views of Earth’s Layered Structure Views of Earth’s Layered Structure
Construct a Lorenz curve that shows income distribution in this society. Construct a Lorenz curve that shows income distribution in this society.
Select the changes in the embryo that indicate that a blastocyst has formed. 3 options: t Select the changes in the embryo that indicate that a blastocyst has formed. 3 options: t
Video: Gastrin (gastric emptying) & Secretin (buffering gastric acid)

For a complete list of videos, visit our video library