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

Author Question: Which of the following best describes the use of DISTINCT with a function as in SUM(DISTINCT )? ... (Read 45 times)

BRWH

  • Hero Member
  • *****
  • Posts: 553
on: Jul 7, 2018
Which of the following best describes the use of DISTINCT with a function as in SUM(DISTINCT )?
 
  A) Only distinct values are totaled, repeated values are ignored
  B) It only sums one row at a time
  C) It has no effect
  D) None of the above

Question 2

Query by example uses a series of keywords and commands to select the rows and columns for a query.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

hanadaa

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

A

Answer to Question 2

FALSE


BRWH

  • Member
  • Posts: 553
Reply 2 on: Jul 7, 2018
:D TYSM

kjohnson

  • Member
  • Posts: 330
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

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?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

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?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Negative control of a repressible set of genes: function of the trp repressor and corepressor in reg Negative control of a repressible set of genes: function of the trp repressor and corepressor in reg
The structure of stomatal guard cells affects their function. The structure of stomatal guard cells affects their function.
How to find an angle in radians for any given trigonometric function How to find an angle in radians for any given trigonometric function
How to prove the derivative of the general logarithmic function How to prove the derivative of the general logarithmic function
Consider the following Lagrangian function: Z(I1,K2,λ) = F(K1,L1) - I1 - w1L1 ... Consider the following Lagrangian function: Z(I1,K2,λ) = F(K1,L1) - I1 - w1L1 ...
Calculus help: Find a cubic function f (x) = ax3 +bx2 +cx+d that has a local maximum value of 3 ... Calculus help: Find a cubic function f (x) = ax3 +bx2 +cx+d that has a local maximum value of 3 ...
Video: What is Cholesterols? Introduction to Lipoproteins

For a complete list of videos, visit our video library