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,004 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,587 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,833 reads

Type INT

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

Round averages

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

SUM()

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

Count Function Result (2)

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

Count Function Result (1)

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

NULL Aggregates

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

Sum and Count

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

COUNT() Function

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