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

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

More than 4.4billion prescriptions were dispensed within the United States in 2016.

Did you know?

Though methadone is often used to treat dependency on other opioids, the drug itself can be abused. Crushing or snorting methadone can achieve the opiate "rush" desired by addicts. Improper use such as these can lead to a dangerous dependency on methadone. This drug now accounts for nearly one-third of opioid-related deaths.

Did you know?

Patients who cannot swallow may receive nutrition via a parenteral route—usually, a catheter is inserted through the chest into a large vein going into the heart.

Did you know?

Fungal nail infections account for up to 30% of all skin infections. They affect 5% of the general population—mostly people over the age of 70.

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)
The respiratory system: nasal cavity, pharynx, larynx, trachea, bronchus, and lung with expanded vie The respiratory system: nasal cavity, pharynx, larynx, trachea, bronchus, and lung with expanded vie
Three views of neurulation in an amphibian embryo Three views of neurulation in an amphibian embryo
Views of Hard Stabilization Views of Hard Stabilization
How to convert verbal statements into algebraic equations (Part 1) How to convert verbal statements into algebraic equations (Part 1)
Views of Earth’s Layered Structure Views of Earth’s Layered Structure
Video: ADH and the arterioles, kidneys, sweat glands and the Atrial natriuretic peptide (ANP)

For a complete list of videos, visit our video library