How to use an ALIAS in a PostgreSQL ORDER BY clause?

by

You can always ORDER BY this way:

select 
    title, 
    ( stock_one + stock_two ) as global_stock
from product
order by 2, 1

or wrap it in another SELECT:

SELECT *
from
(
    select 
        title, 
        ( stock_one + stock_two ) as global_stock
    from product
) x
order by (case when global_stock = 0 then 1 else 0 end) desc, title

More Related Contents:

  1. How to return result of a SELECT inside a function in PostgreSQL?
  2. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  3. Possible to perform cross-database queries with PostgreSQL?
  4. Reset auto increment counter in postgres
  5. Optimize query with OFFSET on large table
  6. GROUP BY and aggregate sequential numeric values
  7. Safely rename tables using serial primary key columns
  8. How to concatenate columns in a Postgres SELECT?
  9. How to use (install) dblink in PostgreSQL?
  10. get JOIN table as array of results with PostgreSQL/NodeJS
  11. updating table rows in postgres using subquery
  12. How can I send email from PostgreSQL trigger?
  13. Find overlapping date ranges in PostgreSQL
  14. Postgres manually alter sequence
  15. What’s the proper index for querying structures in arrays in Postgres jsonb?
  16. “Operator does not exist: integer =?” when using Postgres
  17. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  18. Postgres sql insert query syntax error from phpPgAdmin
  19. Aggregate a single column in query with many columns
  20. Aggregating (x,y) coordinate point clouds in PostgreSQL
  21. PostgreSQL convert columns to rows? Transpose?
  22. Does Postgres support nested or autonomous transactions?
  23. PostgreSQL delete with inner join
  24. Regular expression in PostgreSQL LIKE clause
  25. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  26. Update a column of a table with a column of another table in PostgreSQL
  27. Check if NULL exists in Postgres array
  28. Generate DEFAULT values in a CTE UPSERT using PostgreSQL 9.3
  29. How to use SQL LIKE condition with multiple values in PostgreSQL?
  30. Is there a postgres CLOSEST operator?

Leave a Comment