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
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
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
Frank
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: Sat Dec 10 09:10:45 CST 2016

Total time taken to generate the page: 0.08036 seconds