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

Content with tags T-SQL, Aggregates Rss

<< Newer    Items 21 to 34 of 34   

How well do you know MAX?

By VM-723206 2011/08/05 | Category: max()
Rating: (not yet rated) |  Discuss |   Briefcase | 3,265 reads

AVG function

By krishnaroopa senthil 2011/06/21 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,697 reads

SQL Function to get Max, Min values from given collection of values

This func returns the max value,min value and count of values from collection of values  Read more...
By Bharat Panthee 2011/01/20 | Source: SQLServerCentral.com | Category: aggregates
Rating: |  Discuss |   Briefcase | 1,724 reads

Using OVER with an Aggregate Function

By Nakul Vachhrajani 2010/11/04 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,192 reads

Generating SubTotals using GROUPING

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.  Read more...
By Sunil Chandurkar 2012/11/16 (first published: 2010/07/13) | Source: SQLServerCentral.com | Category: groouping
Rating: |  Discuss |   Briefcase | 26,680 reads


By Prakriti Agrawal 2010/03/09 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,344 reads

Three Sample reports for the Automated DBA: Space Usage SnapShotter

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...
By Jesse Roberge 2009/07/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,404 reads

Median Workbench

SQL Server database engine doesn't have a MEDIAN() aggregate function. This is probably because there are several types of median, such as statistical, financial or vector medians. Calculating Medians are essentially a row-positioning task, since medians are the middle value of an ordered result. Easy to do in SQL? Nope. Joe Celko explains why.  Read more...
By Additional Articles 2009/05/06 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 1,920 reads

SUM of FLOAT inconsistency

By brewmanz 2008/10/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,654 reads

Accessing and changing data 2008

By bitbucket-25253 2008/09/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,787 reads

Summarizing Data with Aggregate Queries - SQL School Video

Learn how to summarize the values of your data using aggregate functions such as COUNT(), SUM(), and AVG() from MVP Kathi Kellenberger. Grouping and aggregate filters are covered as well.  Read more...
By Kathi Kellenberger 2008/08/28 | Source: SQLServerCentral.com | Category: video
Rating: |  Discuss |   Briefcase | 4,895 reads

Calculating Mathematical Values in SQL Server

In our application we have the need to perform mathematical calculations. Right now we are doing so in our front end application. Unfortunately we are starting to experience performance problems with large data sets and differences in calculations due to developers using different logic. We are seeking some other options to perform the calculations. Does SQL Server perform basic mathematical calculations?  Read more...
By Additional Articles 2008/08/07 | Source: MSSQLTips.com | Category: t-sql
Rating:  Rate this |   Briefcase | 5,481 reads

Windowed Aggregate functions

By Matt Miller (4) 2008/06/27 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 5,073 reads

Aggregating Correlated Sub-Queries

Every now and then you may attempt to calculate an aggregate function -- such as SUM() -- on a correlated subquery, only to encounter the following error:  Read more...
By Additional Articles 2007/10/29 | Source: SQLTeam.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,708 reads
<< Newer    Items 21 to 34 of 34   
count() (7)    
max() (2)    
null (2)    
administration (1)    
automated dba (1)    
date manipulation (1)    
groouping (1)    
group by (1)    
growth trend (1)    
maintenance (1)    
maintenance and management (1)    
median (1)    
ranking functions (1)    
report (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)