how to write a criteria involved with count, group

[jill han]

How can I write a criteria that is equivalent to:

SELECT USER_NAME, COUNT(USER_NAME) NUMOFUSERS
FROM USERTABLE
WHERE USER_ID = 0000
GROUP BY USER_NAME;

Thanks in advance.
Jill


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]