MulaiMulai sekarang secara gratis

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

Latihan ini adalah bagian dari kursus

Introduction to Oracle SQL

Lihat Kursus

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

-- Select the relevant columns and filter based on the condition
SELECT ___, ___
FROM ___
___ ___ ___ ___
Edit dan Jalankan Kode