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

Author Question: Count function does which of the following? A) Returns the number of values in the column for the ... (Read 78 times)

jlmhmf

  • Hero Member
  • *****
  • Posts: 552
on: Jul 7, 2018
Count function does which of the following?
 
  A) Returns the number of values in the column for the selected rows
  B) Returns the highest value in the column for the selected rows
  C) Returns the total of the values in the column for the selected rows
  D) Returns the average of the values in the column for the selected rows

Question 2

In Oracle, the statement used to retrieve all the jobs with jobid greater than 5 and less than 8,
  displaying only jobids and associated dates, would be which of the following?
 
  A) Select jobid, date From Job Where jobid 5 and 8
  B) Select jobid, date From Job Where jobid >5 And <8
  C) Select jobid, date From Job Where jobid >=5 and <=8
  D) Select jobid, date From Job Where jobid between 5 and 8


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jxjsniuniu

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

A

Answer to Question 2

B


jlmhmf

  • Member
  • Posts: 552
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

abro1885

  • Member
  • Posts: 337
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Never take aspirin without food because it is likely to irritate your stomach. Never give aspirin to children under age 12. Overdoses of aspirin have the potential to cause deafness.

Did you know?

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

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

There are over 65,000 known species of protozoa. About 10,000 species are parasitic.

pH Values of Some Familiar Substances pH Values of Some Familiar Substances
Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry. Pulmonary function test: spirometry. (a) Normal respiratory volumes, as measured during spirometry.
Attributed to Apollodorus, Column of Trajan, Rome (detail). Attributed to Apollodorus, Column of Trajan, Rome (detail).
Correlations between scores on a psychology test and number of boiled kumquats eaten per month Correlations between scores on a psychology test and number of boiled kumquats eaten per month
Posterior pituitary function Posterior pituitary function
Thyroid Function Thyroid Function
Video: Rods and Cones Animation

For a complete list of videos, visit our video library