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,
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid'
This query will return all the Hybrid cars.
Please note, that in that case, you have to use single quotes, not double!
Obrigado pelo seu feedback!
single
Word filtering
Deslize para mostrar o menu
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,
123SELECT * FROM audi_cars WHERE fueltype = 'Hybrid'
This query will return all the Hybrid cars.
Please note, that in that case, you have to use single quotes, not double!
Deslize para começar a programar
From audi_cars table extract only cars with Automatic transmission. Extract all the columns.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
single
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
