|running count distinct cognos||1.38||1||7042||35|
Cognos is IBM's business intelligence (BI) and performance management software suite. The software is designed to enable business users without technical knowledge to extract corporate data, analyze it and assemble reports.What is the command for a count distinct?
SQL COUNT () function with DISTINCT clause eliminates the repetitive appearance of the same data. The DISTINCT can come only once in a given select statement. COUNT (DISTINCT expr, [expr...]) To get unique number of rows from the 'orders' table with following conditions -What is a distinct count?
DISTINCT COUNT(*) will return a row for each unique count. What you want is COUNT(DISTINCT expression): evaluates expression for each row in a group and returns the number of unique, nonnull values. I needed to get the number of occurrences of each distinct value. The column contained Region info.