Sort data in BigQuery using order [closed]

Question

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

This question does not appear to be about programming within the scope defined in the help center.

Closed last month.

The community reviewed whether to reopen this question last month and left it closed:

Original close reason(s) were not resolved

I am learning BigQuery in Coursera. I am trying to sort a table but I am confused about how to use ORDER BY.

My table has columns like name and age. I want to sort the age from highest to lowest. What is the correct SQL query to do this?

What exactly are you confused by? It's very straightforward and the documentation is clear — Dale K
– Dale K, Commented Mar 13 at 22:57
You should also show us what you tried and why it didn't work? — Dale K
– Dale K, Commented Mar 13 at 22:59
docs.cloud.google.com/bigquery/docs/reference/standard-sql/… — Dale K
– Dale K, Commented Mar 13 at 23:31
1) Just read documentation to answer your question, 2) Do not use a single column name, better separate columns for first name and last name. 3) Do not use a column age because you need to update it quite often or the age will be incorrect. Avoid this trouble and rather use a column date_of_birth. — Jonas Metzler
– Jonas Metzler, Commented Mar 14 at 4:07

Tinyfold · Accepted Answer · 2026-03-13 22:57:22Z

1

Simply use it like this:

SELECT name, age
FROM your_table
ORDER BY age DESC;

The syntax is to first do ORDER BY, then mention the column. Finally, if you want descending order, use DESC. Ascending is default.

answered Mar 13 at 22:57

Tinyfold

4332 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonas Metzler Mar 14 at 17:14

You can also order by multiple columns or no columns, but expressions/conditions.

Dale K Mar 15 at 23:00

There is no benefit in just, partially, reproducing official documentation - you need to add additional clarification, link to the source, and mention that this is only one way to use it.

Collectives™ on Stack Overflow

Sort data in BigQuery using order [closed]

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related