Picking columns

SELECT * returns every column. Usually you want only a few. Instead of *, list the columns you want, separated by commas:

SELECT name, score FROM student;

The result has just those columns, in the order you wrote them.

Renaming a column with AS

You can rename a column in the result with AS. This does not change the table — only the heading shown:

SELECT name AS pupil, score AS mark FROM student;

The headings become pupil and mark. This is handy for clear reports.

Explore

Choosing columns keeps only the fields you name.

Select only the name and score columns from student, in that order.

-- Name the two columns you want, separated by a comma:
SELECT FROM student;

Click Run to see the output here.

Select name and score, but rename the headings to pupil and mark using AS.

SELECT name, score FROM student;

Click Run to see the output here.