[ACCEPTED]-SQL ignore case in group by? (oracle)-group-by

Accepted answer

Score: 30

Just use UPPER:

select upper(state), count(1)
  from your_table
 group by upper(state);

0

Source: stackoverflow.com

More Related questions

SQL Group By - counting records per month/year, error on insert - NOT A VALID MONTH

SQL select & group by a period of time (timestamp)

Oracle SQL group row count by time intervals of 10 minutes

Need to count records and group count by date on oracle db using sql developer

LINQ GROUP BY and MAX()

Group by date range on weeks/months interval

How can I select the longest text field when using GROUP BY in mysql, a la MAX()?

Get row with highest or lowest value from a GROUP BY

SQL: GROUP BY for number ranges?

PostgreSQL group by without aggregate function. Why does it work?

Cookie Warning

We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.