Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is difference between count(*) and count(1)

Status
Not open for further replies.
naren044

naren044

Programmer
May 1, 2008
7
IN
What is difference between count(*) and count(1)
 
Sort by date Sort by votes
Functionally they are identical. Depending on the implementation (the RDBMS and version) the one or the other may be a trfile quicker.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

RJKumar
  • Locked
  • Question
How to build Dimensional model for commission received and return
Replies
1
Views
297
johnherman
johnherman
Sohailaziz
  • Locked
  • Question
Difference and Usefulness of SSIS and SSAS 1
Replies
3
Views
129
johnherman
johnherman
mike2228
  • Locked
  • Question
what type of constraint is this?
Replies
3
Views
95
johnherman
johnherman
Skittle
  • Locked
  • Question
What Is A 'Slice' In Slice And Dice? 1
Replies
4
Views
84
MDXer
MDXer
dbrs4me
  • Locked
  • Question
Book Search - Oracle OWB and OBIEE
Replies
0
Views
67
dbrs4me
dbrs4me

Part and Inventory Search

Sponsor

Back
Top