Group by alias (Oracle)

by 
select
  count(count_col),
  alias_column
from
  (
  select 
    count_col, 
    (select value from....) as alias_column 
  from 
    table
  ) as inline
group by 
  alias_column

Grouping normally works if you repeat the respective expression in the GROUP BY clause. Just mentioning an alias is not possible, because the SELECT step is the last step to happen the execution of a query, grouping happens earlier, when alias names are not yet defined.

To GROUP BY the result of a sub-query, you will have to take a little detour and use an nested query, as indicated above.

More Related Contents:

  1. How do I limit the number of rows returned by an Oracle query after ordering?
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. When do I need to use a semicolon vs a slash in Oracle SQL?
  4. LISTAGG in Oracle to return distinct values
  5. Is there an Oracle SQL query that aggregates multiple rows into one row? [duplicate]
  6. How to handle a single quote in Oracle SQL
  7. Select count(*) from multiple tables
  8. REGEX to select nth value from a list, allowing for nulls
  9. Concatenate and group multiple rows in Oracle [duplicate]
  10. Difference between BYTE and CHAR in column datatypes
  11. How to use BOOLEAN type in SELECT statement
  12. Call a stored procedure with another in Oracle
  13. create table with sequence.nextval in oracle [duplicate]
  14. Convert a string date into datetime in Oracle
  15. WHERE IN condition not accepting String value
  16. What is the difference between Views and Materialized Views in Oracle?
  17. Benefits Of Using SQL Ordinal Position Notation?
  18. ORA-00907: missing right parenthesis
  19. Oracle Dynamic Pivoting
  20. Foreign Key Creation issue in Oracle
  21. Custom Order in Oracle SQL
  22. How do I list all tables in a schema in Oracle SQL?
  23. Is there a version control system for database structure changes?
  24. oracle sql: update if exists else insert [duplicate]
  25. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  26. Compare Strings ignoring accents in SQL (ORACLE)
  27. Search an Oracle database for tables with specific column names?
  28. How to replace specific values in a oracle database column?
  29. Query a Table’s Foreign Key relationships
  30. is there a PRODUCT function like there is a SUM function in Oracle SQL?

Leave a Comment