Sveip for å vise menyen

SELECTing certain columns

Let's dig into our database. This database has 9 columns:

model - model of the car
year - year of manufacture
price - car price in Euros
transmission - type of gearbox
mileage - miles drove
fueltype - engine fuel type
tax - road tax
mpg - miles per gallon
enginesize - engine size in liters.

To extract certain columns you need to select them by their names, like:


              12
            
SELECT 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.

Oppgave

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 nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 2

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

SELECTing certain columns

Let's dig into our database. This database has 9 columns:

model - model of the car
year - year of manufacture
price - car price in Euros
transmission - type of gearbox
mileage - miles drove
fueltype - engine fuel type
tax - road tax
mpg - miles per gallon
enginesize - engine size in liters.

To extract certain columns you need to select them by their names, like:


              12
            
SELECT 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.

Oppgave

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 nedenfor

Alt var klart?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 2

Bytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor