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:
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.
Swipe to start coding
Extract columns model, year, and price from the audi_cars database.
Løsning
Takk for tilbakemeldingene dine!
single
Spør AI
Spør AI
Spør om hva du vil, eller prøv ett av de foreslåtte spørsmålene for å starte chatten vår
Oppsummer dette kapittelet
Explain code
Explain why doesn't solve task
Awesome!
Completion rate improved to 2.63SELECTing certain columns
Sveip for å vise menyen
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:
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.
Swipe to start coding
Extract columns model, year, and price from the audi_cars database.
Løsning
Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenforTakk for tilbakemeldingene dine!
single
