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

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

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?

Once thought to have neurofibromatosis, Joseph Merrick (also known as "the elephant man") is now, in retrospect, thought by clinical experts to have had Proteus syndrome. This endocrine disease causes continued and abnormal growth of the bones, muscles, skin, and so on and can become completely debilitating with severe deformities occurring anywhere on the body.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

Nearly 31 million adults in America have a total cholesterol level that is more than 240 mg per dL.

The arrangement of the external eye muscles: (A) lateral and (B) anterior views. The arrangement of the external eye muscles: (A) lateral and (B) anterior views.
Views of Hard Stabilization Views of Hard Stabilization
Psychosocial Views: Erik Erikson Psychosocial Views: Erik Erikson
Select Signs and Symptoms of Feeding and Eating Disorders Select Signs and Symptoms of Feeding and Eating Disorders
Construct a Lorenz curve that shows income distribution in this society. Construct a Lorenz curve that shows income distribution in this society.
Comparison of Voter Turnout among select nations Comparison of Voter Turnout among select nations
Video: Photosynthesis overview Animation

For a complete list of videos, visit our video library