Home » SQL & PL/SQL » SQL & PL/SQL » significance of count(1)
significance of count(1) [message #227782] Thu, 29 March 2007 07:14 Go to next message
Messages: 111
Registered: November 2006
Senior Member
what is the difference between count(1), or count(2), or count(3) etc...and count(*) ?
i dont see any difference at all...but i am curious to know why sometimes count(1)
is used?

i have tried it, and i get the same result bothways

Re: significance of count(1) [message #227784 is a reply to message #227782] Thu, 29 March 2007 07:21 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
There is NO difference. Read this
Previous Topic: Select Statement suddenly takes very long!
Next Topic: Pagination (Merged)
Goto Forum:

Current Time: Sun Oct 23 05:07:01 CDT 2016

Total time taken to generate the page: 0.10160 seconds