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 <>
.
Cet exercice fait partie du cours
Introduction to Oracle SQL
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
-- Select the relevant columns and filter based on the condition
SELECT ___, ___
FROM ___
___ ___ ___ ___