1

I want to make a select NAM, COUNT(*) as cnt on a table, but I want the count to function in case sensitive matter. For example, if the NAM attribute has the following 2 values:

DEV
dev

I would like cnt for each value to be 1 (to have 2 rows in result), and not cnt=2 (to have one row in result).

How can I do this in Teradata?

Adam
  • 2,347
  • 12
  • 55
  • 81

1 Answers1

2

You need to specify CASESPECIFIC on your grouped column:

select
NAM (CASESPECIFIC),
count (*)
from
<your table>
group by 1

Here's some good info on this topic.

Andrew
  • 8,445
  • 3
  • 28
  • 46