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 85 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

raili21

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The word drug comes from the Dutch word droog (meaning "dry"). For centuries, most drugs came from dried plants, hence the name.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Automated pill dispensing systems have alarms to alert patients when the correct dosing time has arrived. Most systems work with many varieties of medications, so patients who are taking a variety of drugs can still be in control of their dose regimen.

Did you know?

This year, an estimated 1.4 million Americans will have a new or recurrent heart attack.

Did you know?

Approximately one in four people diagnosed with diabetes will develop foot problems. Of these, about one-third will require lower extremity amputation.

Hemodialysis. The process of hemodialysis replaces the kidney function of blood filtration by forcin Hemodialysis. The process of hemodialysis replaces the kidney function of blood filtration by forcin
How to transform the natural exponential function (e^x) How to transform the natural exponential function (e^x)
The Dietary Reference Intakes Are Reference Values for Each Nutrient The Dietary Reference Intakes Are Reference Values for Each Nutrient
Write equation for each function Write equation for each function
Periodic Function Periodic Function
Find the value exponential and log function Find the value exponential and log function
Video: Cardiac Cycle (Part 1 of 4)

For a complete list of videos, visit our video library