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,130 reads

SQL query

By Mohammad Tanweer Khan 2016/03/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 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

The Lonely Count

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

The TOP 10 Count

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

Counting Rows

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

Group By, Count, and NULLs

By Justin Clementz 2015/02/02 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,322 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,266 reads

Getting Distinct

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

Distinct Counts

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

COUNT NULLs

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

Counting values

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

COUNT, COALESCE, ISNULL, DISTINCT

By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,731 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,266 reads

T-SQL counts

By Samith C 2013/10/02 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,859 reads

Sum and Count

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

COUNT() Function

By Yogesh Kumar 2013/04/16 | Category: count()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,561 reads

Basic of T-SQL

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

What's the count?

By Slick84 2010/03/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,729 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)