Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Sorting by Multiple Columns | Sorting Data
Introduction to SQL

bookSorting by Multiple Columns

Summary:

  • The retrieved data can be sorted with respect to the values of multiple columns as well using the ORDER BY clause;
  • The general syntax of the ORDER BY clause is: SELECT column1, column2, … FROM table_name ORDER BY columnA [ASC|DESC], columnB [ASC|DESC], …;;
  • SELECT name, age FROM students ORDER BY age, first_name.
question mark

In case of the expression ORDER BY age, first_name, the fetched rows are sorted first by:

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 3

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Awesome!

Completion rate improved to 1.72

bookSorting by Multiple Columns

Swipe to show menu

Summary:

  • The retrieved data can be sorted with respect to the values of multiple columns as well using the ORDER BY clause;
  • The general syntax of the ORDER BY clause is: SELECT column1, column2, … FROM table_name ORDER BY columnA [ASC|DESC], columnB [ASC|DESC], …;;
  • SELECT name, age FROM students ORDER BY age, first_name.
question mark

In case of the expression ORDER BY age, first_name, the fetched rows are sorted first by:

Select the correct answer

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 3. ChapterΒ 3
some-alt