The best replacement for distinct is distinctive.

The best alternatives to distinct are rated as following:
★★★★★  distinctive
★★  group by
★★  unique
★  distinctrow
★  group by performance
★  group by oracle
★  different
★  group by sql server
★  unique oracle
★  group by mysql
★  select unique
  top 1
  coincident
  separate
  group by faster
  distinguished
  group by teradata
  unique sql
  group by sql
  distinct row
  exists
  unique mysql

Your alternative for distinct is not listed? Suggest!
Speaking about distinct, one probably shouldn't forget about count.

Other search terms related to distinct and their ratings are:
★★★★★ count
★★★ order by
★★★ multiple columns
★★ aggregate function
★★ row_number in sql
★ multiple fields
★ union
★ count in sql
sql query
distinct
You have in mind a companion for distinct and it is not yet here? Propose!



Google Trends

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