BETA
Session Ready
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
undefined XP
  • 1

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

    • 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.