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!
フィードバックありがとうございます!
single
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!
スワイプしてコーディングを開始
From audi_cars table extract only cars with Automatic transmission. Extract all the columns.
解答
フィードバックありがとうございます!
single
AIに質問する
AIに質問する
何でも質問するか、提案された質問の1つを試してチャットを始めてください