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

Content with tags T-SQL, Aggregate Function Rss

   Items 1 to 11 of 11   
 

Calculating the Tally

By Steve Jones 2017/09/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,122 reads

SQL Data Aggregation Aggravation

When we have to deal with and store a lot of data, it makes sense to aggregate it so that we store only the information we actually need. If we get this right, this works well, but the design of the system takes care and thought because the problems can be subtle and various. Joe Celko describes some of the ways that things can go wrong and end up providing incorrect, inaccurate or misleading results.  Read more...
By Additional Articles 2017/09/12 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 3,756 reads

Curious Case of SUM Function

How a simple SUM statement could change an output.  Read more...
By Utsav Verma 2017/08/24 | Source: SQLServerCentral.com | Category: sum()
Rating: |  Discuss |   Briefcase | 1,915 reads

Type INT

By Lesole Sebego 2016/11/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,363 reads

Round averages

By Steve Jones 2016/09/29 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 1,352 reads

SUM()

By Sasidhar Pulivarthi 2016/05/20 | Category: sum
Rating: (not yet rated) |  Discuss |   Briefcase | 1,733 reads

Count Function Result (2)

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

Count Function Result (1)

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

NULL Aggregates

By Steve Jones 2015/01/07 | Category: aggregate function
Rating: (not yet rated) |  Discuss |   Briefcase | 2,303 reads

Sum and Count

By G. C. 2013/04/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,650 reads

COUNT() Function

By Yogesh Kumar 2013/04/16 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,574 reads
   Items 1 to 11 of 11   
 
Tags
count() (4)    
sum() (3)    
sum (2)    
datatype (1)    
decimal (1)    
numeric (1)    
round() (1)