Selecting columns

- You can choose which columns…to return in a query by listing…the columns in your select statement.…Choose the world database here…and type in a simple query.…Select everything from the country table,…and when I press go you see we get 239 rows…and all of the columns here in the table.…So if I want to select specific columns, I can say…name, continent, and region.…

And if I press go I get name, continent, and region.…That's only the listed columns now.…I've selected which columns to return in my…query by listing them in the select statement.…Of course, if I don't like the word "Name" here as the…identifier for that column, I can change that…and I can say "As Country," and when I press "Go"…now that column is named "Country" instead of "Name."…And I can list the columns in any order if I like.…

If I want continent and region before name, I can…list them in that order and then when I press "Go"…I now get continent, region, and country, instead of…country, continent, and region.…You may choose which columns to return…