Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda Word filtering | Filtering
SQL Basics

book
Word filtering

Imagine that we want to extract all the hybrid cars from our database. As you understand, doing it manually is a worthless job and has to be automated.

Surely it has already been implemented! To filter observations based on columns with text use WHERE statement. For example,

SELECT *
FROM audi_cars
WHERE fueltype = 'Hybrid'
123
SELECT * FROM audi_cars WHERE fueltype = 'Hybrid'
copy

This query will return all the Hybrid cars.

Please note, that in that case, you have to use single quotes, not double!

Tarefa

Swipe to start coding

From audi_cars table extract only cars with Automatic transmission. Extract all the columns.

Solução

SELECT *
FROM audi_cars
WHERE transmission = 'Automatic'

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 2. Capítulo 1
single

single


Query ResultQuery Result
No query executed yet...

Pergunte à IA

expand

Pergunte à IA

ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

We use cookies to make your experience better!
some-alt