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.

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.