I ran this query on a view:

SELECT * FROM JAM_VIEW; -> returned 2154 rows.

SELECT COUNT(*) FROM JAM_VIEW; -> returned 171 rows.

Is it not weird? Any idea how could this is possible?