Question: Suppose the invoice table has a total column that contains positive decimal numbers. You want to write a query that returns records where the total

Suppose the invoice table has a total column that contains positive decimal numbers. You want to write a query that returns records where the total is greater than 4.99.
Which of these statements will achieve that?
a.)
SELECT * FROM invoice
WHERE total >5;
b.)
SELECT FROM invoice
WHERE total <4.99;
c.)
SELECT * FROM invoice
WHERE total >4.99;
d.)
SELECT * FROM invoice
WHERE total >=4.99;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!