SELECTing certain columns
Let's dig into our database. This database has 9 columns:
model
- model of the caryear
- year of manufactureprice
- car price in Eurostransmission
- type of gearboxmileage
- miles drovefueltype
- engine fuel typetax
- road taxmpg
- miles per gallonenginesize
- engine size in liters.
To extract certain columns you need to select them by their names, like:
9
1
2
SELECT column1, column2, column3
FROM table_name
12SELECT column1, column2, column3 FROM table_name
Please note, that SQL is also case-insensitive to column names, i.e. if the column has name id both notations id
and ID
will be interpreted the same.
Aufgabe
Swipe to start coding
Extract columns model
, year
, and price
from the audi_cars
database.
Lösung
9
1
2
SELECT model, year, price
FROM audi_cars
War alles klar?
Danke für Ihr Feedback!
Abschnitt 1. Kapitel 2
single
9
1
No query executed yet... |
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen