Marco Antonio C. Santos wrote:
> How can I do MySQL works fine with this simple query:
>
> SELECT DISTINCT User_ID,(SELECT Count(User_ID) FROM users p1 WHERE
> p1.User_ID = users.User_ID) AS CountID
> FROM users

SELECT User_ID, count(User_ID)
FROM users
GROUP BY User_ID

Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to