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 25 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
:D TYSM

xiazhe

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

« previous next »
 

Did you know?

The familiar sounds of your heart are made by the heart's valves as they open and close.

Did you know?

To maintain good kidney function, you should drink at least 3 quarts of water daily. Water dilutes urine and helps prevent concentrations of salts and minerals that can lead to kidney stone formation. Chronic dehydration is a major contributor to the development of kidney stones.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

To prove that stomach ulcers were caused by bacteria and not by stress, a researcher consumed an entire laboratory beaker full of bacterial culture. After this, he did indeed develop stomach ulcers, and won the Nobel Prize for his discovery.

A number of tree species can be interconnected by mycorrhizal fungi in the forests of British Columb A number of tree species can be interconnected by mycorrhizal fungi in the forests of British Columb
Critical lab Values Critical lab Values
The strange situation. The Strange Situation features a series of episodes in which (a) the mother l The strange situation. The Strange Situation features a series of episodes in which (a) the mother l
Testing motor function of cranial nerve VII - Close both eyes Testing motor function of cranial nerve VII - Close both eyes
Ferris Wheel Periodic Function Ferris Wheel Periodic Function
Mitochondrial structure and function Mitochondrial structure and function
Video: Hormonal regulation of pregnancy - weeks 17 through 38

For a complete list of videos, visit our video library