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

Content with tags T-SQL, Aggregates Rss

   Items 1 to 20 of 47    Older >>
 

Cube v rollup

By Steve Jones 2017/12/14 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 968 reads

The Difference Between Rollup and Cube

Learn about the fundamental differences between the ROLLUP and CUBE operators.  Read more...
By Ben Richardson 2017/11/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,596 reads

Calculating the Tally

By Steve Jones 2017/09/18 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,136 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,790 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,917 reads

I want back my Points

By Carlo Romagnano 2017/04/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,436 reads

Type INT

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

Round averages

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

SUM()

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

More GROUP BY

By Steve Jones 2016/03/24 | Category: group by
Rating: (not yet rated) |  Discuss |   Briefcase | 1,680 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

Counting Rows

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

Not Again!

By Steve Knox 2015/02/18 | Category: aggregates
Rating: (not yet rated) |  Discuss |   Briefcase | 2,500 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

Counting values

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

NULL Aggregates

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

Bean Counting

By PhyData DBA 2014/05/12 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,119 reads
   Items 1 to 20 of 47    Older >>
 
Tags
count() (11)    
sum() (3)    
cube (2)    
max() (2)    
null (2)    
rollup (2)    
sum (2)    
administration (1)    
automated dba (1)    
datatype (1)    
date manipulation (1)    
decimal (1)    
groouping (1)    
group by (1)    
growth trend (1)    
maintenance (1)    
maintenance and management (1)    
median (1)    
numeric (1)    
ranking functions (1)    
report (1)    
round() (1)    
running aggregate (1)    
running totals (1)    
security (1)    
space usage (1)    
sql server 2005 (1)    
storage (1)    
to us (1)    
utility (1)    
video (1)