SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag count() Rss

   Items 1 to 20 of 30    Older >>
 

Basic COUNTs 4

By Steve Jones 2018/02/09 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,000 reads

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,175 reads

Basic COUNTs 3

By Steve Jones 2018/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,060 reads

Basic COUNTs 2

By Steve Jones 2018/01/26 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,062 reads

Basic COUNTs 1

By Steve Jones 2018/01/19 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 1,118 reads

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.  Read more...
By Bill Pearson 2017/11/29 | Source: SQLServerCentral.com | Category: dax
Rating: (not yet rated) |  Discuss |   Briefcase | 412 reads

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.  Read more...
By Bill Pearson 2017/07/12 (first published: 2015/01/07) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,062 reads

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2018/02/09 (first published: 2016/07/12) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,175 reads

SQL query

By Mohammad Tanweer Khan 2016/03/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,760 reads

Count Function Result (2)

By G. C. 2016/01/25 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,762 reads

Count Function Result (1)

By G. C. 2016/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,742 reads

The Lonely Count

By Steve Jones 2016/01/07 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,663 reads

The TOP 10 Count

By Eirikur Eiriksson 2015/10/22 | Category: top
Rating: (not yet rated) |  Discuss |   Briefcase | 1,812 reads

Counting Rows

By Shiva N 2015/08/31 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,032 reads

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,334 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2015/01/30 (first published: 2013/10/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,271 reads

Getting Distinct

By Steve Jones 2015/01/23 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,596 reads

Distinct Counts

By Steve Jones 2015/01/22 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,399 reads

COUNT NULLs

By Steve Jones 2015/01/21 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,547 reads

Function for String Occurences Count

This function is used to get the particular string occurences count from the given input string.  Read more...
Rating: |  Discuss |   Briefcase | 1,110 reads
   Items 1 to 20 of 30    Older >>
 
Tags
t-sql (23)    
aggregates (7)    
aggregate function (4)    
null (3)    
dax (2)    
calculation (1)    
card (1)    
coalesce() (1)    
column (1)    
counta() (1)    
countax() (1)    
countx() (1)    
delimited (1)    
distinct (1)    
filter (1)    
formula (1)    
function (1)    
group by (1)    
isnull (1)    
matrix (1)    
measure (1)    
power bi (1)    
power bi desktop (1)    
powerpivot (1)    
report (1)    
slicer (1)    
stairway series (1)    
string (1)    
string manipulation (1)    
string occurences (1)    
sum (1)    
sum() (1)    
top (1)    
top 100 (1)    
visualization (1)    
window functions (1)