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,054 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,651 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,858 reads

Type INT

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

Round averages

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

SUM()

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

Count Function Result (2)

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

Count Function Result (1)

By G. C. 2016/01/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,724 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,635 reads

COUNT() Function

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