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

Content with tags T-SQL, count() Rss

   Items 1 to 20 of 20   
 

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.  Read more...
By Igor Micev 2016/07/12 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,128 reads

SQL query

By Mohammad Tanweer Khan 2016/03/07 | Category: t-sql
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,739 reads

Count Function Result (1)

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

The Lonely Count

By Steve Jones 2016/01/07 | Category: window functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,649 reads

The TOP 10 Count

By Eirikur Eiriksson 2015/10/22 | Category: top
Rating: (not yet rated) |  Discuss |   Briefcase | 1,799 reads

Counting Rows

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

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,317 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2015/01/30 (first published: 2013/10/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,262 reads

Getting Distinct

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

Distinct Counts

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

COUNT NULLs

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

Counting values

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

COUNT, COALESCE, ISNULL, DISTINCT

By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,730 reads

Using a column name in a COUNT function

Putting a column name in a COUNT() function may not always give you what you are looking for.  Read more...
By Charles Kincaid 2015/01/30 (first published: 2013/10/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 28,262 reads

T-SQL counts

By Samith C 2013/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,857 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

Basic of T-SQL

By Naseer Ahmad 2012/08/20 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,504 reads

What's the count?

By Slick84 2010/03/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,728 reads
   Items 1 to 20 of 20   
 
Tags
aggregates (7)    
aggregate function (4)    
null (3)    
coalesce() (1)    
distinct (1)    
group by (1)    
isnull (1)    
sum (1)    
top (1)    
window functions (1)