1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Oracle SQL

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.