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

Deslize para mostrar o menu

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,

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

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 2. Capítulo 1
single

single

Pergunte à IA

expand

Pergunte à IA

ChatGPT

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

close

Awesome!

Completion rate improved to 2.63

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,

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

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

close

Awesome!

Completion rate improved to 2.63

Deslize para mostrar o menu

some-alt