difference in number of records for select count(*) and select *

[karpalmera]

We are trying to do select count(*) and select * from the same table.

We have executed the following:
when we execute

SELECT COUNT(*)
FROM TABLE1;
the result is 0
 

but when we execute

SELECT *
FROM TABLE1;

the result is..

COLUMN1   COLUMN2
1                 A
2                 B

two records selected.

what could possibly cause this discrepancy?

[MindBender77]

Hello,

Select (*) - will count the total number of records in the table

Select * - will list all records in the table

[docdiesel]

Hi,

Select (*) - will count the total number of records in the table
Select * - will list all records in the table

Yes, correct. But the "SELECT count(*) should have given 2 as result, not 0 (zero), for there're two rows in the table. Try a

SELECT
  count(column1)
FROM
  table1

or another column. What's the result?

Regards,

Bernd

[karpalmera]

We have REORG the table. This seems to solve the problem. The number of records for select * and select count(*) are now the same.

But I still want to know the reason behind it.

I'll try the select count per column if the problem arises again.

I'll give an update regarding this..Super thanks!

=================================================

Hi,

Yes, correct. But the "SELECT count(*) should have given 2 as result, not 0 (zero), for there're two rows in the table. Try a

SELECT
  count(column1)
FROM
  table1

or another column. What's the result?

Regards,

Bernd