1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
makkiz [27]
4 years ago
9

What statement needs to be included below to retrieve all rows from the Invoices table with InvoiceTotal greater than 100?

Computers and Technology
1 answer:
-Dominant- [34]4 years ago
3 0

ps.setValue(1, 100); statement needs to be included below to retrieve all rows from the Invoices table with InvoiceTotal greater than 100

b. ps.setValue(1, 100);

<u>Explanation:</u>

Here, in this code snippet, we have to return rows of InvoiceDate and InvoiceTotal from the table Invoices only when the InvoiceTotal is greater than 100. PreparedStatement is a subtype of Statement class Java. It is used to parameterize a query.

Since we have to display the records from the Invoice table after checking the condition, we call the method of PreparedStatement class,  ps.setDouble(1,100) as the records start from 1 and end at 100.

You might be interested in
What technology standard is commonly used today for hard drives?
Lisa [10]
Solid-state drive (SSD) is the commonly used technology these days for hard drives .It has pretty advantages over hard disk drive(HDD) .
One advantage is ,its speed is unmatchable to HDD and the data is stored in microchips. Unlike HDD,which uses a mechanical arm with a read/write head to move around and read information from the right location on a storage platter ,it collects information directly from microchips .It is simply the oversized version of USB stick .More reliable and sustainable.
3 0
4 years ago
Which of the following is the best example of potential energy?
Otrada [13]
<span>Potential energy is the energy that is stored in an object due to its position relative to some zero position ,so the answer is " A runner positioned at the start line"</span>
6 0
3 years ago
Read 2 more answers
Write a program that takes a point (x,y) from theuser and find where does the point lies. The pointcan
agasfer [191]

Answer:

C++ Program .

#include<bits/stdc++.h>

using namespace std;

int main()

{

int x,y;//declaring two variables x and y.

string s;//declaring string s..

cout<<"enter x and y"<<endl;

cin>>x>>y;//taking input of x and y..

if(x>=0 &&y>=0) //condition for 1st quadrant..

cout<<"the point lies in 1st Quadrant"<<endl;

else if(x<=0 &&y>=0)//condition for 2nd quadrant..

cout<<"the point lies in 2nd Quadrant"<<endl;

else if(x>=0 &&y<=0)//condition for 3rd quadrant..

cout<<"the point lies in 3rd Quadrant"<<endl;

else //else it is in  4th quadrant..

cout<<"the point lies in 4th Quadrant"<<endl;

cout<<"enter n to terminate the program"<<endl;

while(cin>>s)//if the user has not entered n the program will not terminate..

{

   if(s=="n")

   {

       cout<<"the program is terminated"<<endl;

       exit(0);

   }

   cout<<"you have not entered n please enter n to terminate the program<<endl;

}

}

Explanation:

The above written program is for telling the point lies in which quadrant.I am first declaring two variables x and y.Then after that taking input of x and y after that checking in which quadrant the point lies.

Taking input of the string s declared earlier for program termination the program will keep running until the user enters n.

4 0
3 years ago
WOULD SOMEONE PLEASE ANSWER THIS IVE ASKED TWICE ALREADY!
Rainbow [258]
I think that’s right, hope it helps!:) brainliest??

7 0
3 years ago
-What is/are the goal/s of Business Intelligence systems?
8_murik_8 [283]

Answer: Business intelligence system is a system that is used in the field of business and organizations for generations of the strategy and plans to make decision. This system consist of the business intelligence(BI) tools. It creates a connection in the different information/data and takes them to the business organization.

Business intelligence system has goals like:-

  • Increasing daily sales
  • Fast the growth rate of the business
  • improving the rental performance
  • Gaining more profit

5 0
3 years ago
Other questions:
  • A company wishes to move all of its services and applications to a cloud provider but wants to maintain full control of the depl
    7·1 answer
  • In the Microsoft publisher application, words underlined in red are ____.
    6·1 answer
  • A _____ is an area hosted by a Web server in which project members and colleagues can share documents, models, photos, and other
    6·1 answer
  • Which bus slot provides highest video performance​
    13·1 answer
  • Which network component connects a device with the transmission media?
    9·1 answer
  • What type of link is used to call this file?
    8·1 answer
  • Explain default dictionary in microsoft word​
    9·1 answer
  • Which tool determines whether or not applications, devices, and computers will work with a new operating system, while maintaini
    13·1 answer
  • What are the 6 major forms that Energy can be grouped into?
    10·1 answer
  • If you play video games, please answer these questions it’s for a survey for my game development class!!
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!