OraFAQ Forum: SQL & PL/SQL » select count(1)

Home » SQL & PL/SQL » SQL & PL/SQL » select count(1)

Thu, 22 August 2002 20:48

hanu
Messages: 21
Registered: March 2002

Junior Member

What is the difference between the following two queries:
select count(*) from table_x;

select count(1) from table_x;

Regards,
Hanu.

Fri, 23 August 2002 04:43

pkoteswara rao
Messages: 1
Registered: August 2002

Junior Member

hi
the 1st query gives the count of rows in
table-x

the 2nd query gives the count of 1st column
values excluding nulls.

regards
koti

Previous Topic:	UTL FILE DIR Error
Next Topic:	to get no. of days from 1900 to current date

Goto Forum:

]

Current Time: Tue Apr 23 16:37:04 CDT 2024