datacamp-logo
Course Outline
BETA
Exercise

Comparison operators

You won't always want to retrieve every row in your database. Sometimes it's easier to display specific information needed to answer a specific question.

Let's look have a look at the invoice data. You are asked to retrieve only a selection of the invoices based on the invoice amount.

Remember that you can use the following operators to compare values: <, <=, >, >=, = and <>.

Instructions 1/4
XP
  • 1

    Select the InvoiceId and Total amount from the Invoice table and display rows where the total amount is equal to 3.98.

      Take Hint (-7 XP)
  • 2

    Adapt your query to only include rows where the total amount is greater than 3.98.

  • 3

    Adapt your query to only include rows where the total amount is smaller than or equal to 3.98.

  • 4

    Adapt your query to only include rows where the total amount is not equal to 3.98.