PL/SQL (MOSC)

MOSC Banner

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

edited Dec 12, 2013 3:23PM in PL/SQL (MOSC) 3 commentsAnswered
Hi ,

What is the difference between  count(*) , count(1)
 
select count(*) from emp 

output is : 14

select count(1) from emp

output is  : 14

select count(7) from emp   -- here 7 th column is comm column

output is : 14

Any difference?



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center