Using Oracle SQL

Let say I have a table named STUDENT
this table contains the following columns
STNAME, STTELE, STSCHOOL, STAGE, STPROG

now I have the following two queries

1st )

select STNAME, STTELE, STAGE from STUDENT
group by STNAME, STTELE, STAGE
having
COUNT (*) > 4;

2nd)

select STNAME, STTELE, STAGE from STUDENT
group by STNAME, STTELE, STAGE
having
COUNT (STNAME) > 4 and COUNT (STTELE) > 4 and COUNT (STAGE) > 4;


Are those two queries doing EXACTLY the same thing? In other words, in
COUNT(*), does the asterisk replaces all the columns from the table or does
it replace ONLY the columns listed in the GROUP BY?

thnaks in advance for any help

Ark wrote:
They will not produce the same result, assuming at least one grouping has >4 rows, if
that grouping contains a NULL for one of the columns. That is:

+ COUNT(*) counts all subject rows.

+ COUNT(exp) doesn't count those rows where exp evaluates to NULL.

--
Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
================================================== ============
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS (http://www.firstsql.com)