The best replacement for group by is distinct.

The best alternatives to group by are rated as following:
★★★★★  distinct
★★★★★  order by
★★★  having
★★  distinct sql server
★  distinct oracle
★  distinct which is better
★  distinct mysql
★  over partition
★  partition by
★  distinct faster
★  select distinct
  distinct teradata
  distinct performance
  where
  partition
  distinct mssql
  distinct sql
  distinct quicker

Your alternative for group by is not listed? Suggest!
Speaking about group by, one probably shouldn't forget about rollup.

Other search terms related to group by and their ratings are:
★★★★★ rollup
★★★★ order by
★★★ count
★★★ where
★★★ where clause
★★★ having
★★★ join
★★ sum
★★ aggregate
★★ case statement
★★ multiple columns
★★ union
★ inner join
★ select
★ using aggregate function
aggregate functions
aggregate oracle
condition
subquery
function
max
all columns
aggregate function
join oracle
functions
left join
You have in mind a companion for group by and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of group by in all years. Click on graph for more.
group by
distinct
order by