Final answer:
To sort student records by majors in ascending order, use the SQL statement SELECT * FROM students ORDER BY major ASC;.
Step-by-step explanation:
To list all student records in ascending order of their majors using SQL, you can use a SELECT statement combined with an ORDER BY clause. The ORDER BY clause allows you to sort the results returned by your query. Assuming that you have a table named students and a column named major, the SQL statement would look like this:
SELECT * FROM students ORDER BY major ASC;
This statement will fetch all records from the students table and then order them in ascending order based on the values in the major column. The keyword ASC stands for ascending order, which is the default sorting order in SQL; you could also explicitly write it to make the sorting direction clear.