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 91 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
Great answer, keep it coming :)

DylanD1323

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Oliver Wendell Holmes is credited with introducing the words "anesthesia" and "anesthetic" into the English language in 1846.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

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

Serum Values for Thyroid Function Tests Serum Values for Thyroid Function Tests
How to know when a function is increasing or decreasing using calculus (Part 1) How to know when a function is increasing or decreasing using calculus (Part 1)
Passive stretching enhances joint function. Passive stretching enhances joint function.
Testing motor function of cranial nerve VII - Raise eyebrows Testing motor function of cranial nerve VII - Raise eyebrows
Derivative of Inverse Trig Function Derivative of Inverse Trig Function
Prove that each of the following real functions f has a discontinuity. For each function, ... Prove that each of the following real functions f has a discontinuity. For each function, ...
Video: Hip Animation

For a complete list of videos, visit our video library